Table Population Properties Tab
The Properties Tab in the Table Population window displays additional information about different objects in the Population window, as follows:
- DB query or Root function Source Objects.
- Target LU table.
- Other objects of a Table Population transformation like a Translation or Global.
- Properties of any selected field in a Population object.
Since each object has different properties, the tab’s layout is updated to display them when an object is selected in the map.
The properties include:
- Basic information about the Population object. For example, Name or ID.
- Specific properties of each object. For example, sync method of target LU table.
- Link to open the object. For example, to edit the query or the function.
- Input arguments (source only) or the Inputs default value, if applicable.
Source Object - DB Query Properties
 |
Name - displays the DB query name. Editable field. ID - generated by Fabric. DB Connection - displays the DB interface of the Source Object. Non-editable. SQL - displays the query. To edit it, click the Edit Query link. Edit Query - a link to the Query Builder. Input Arguments - displays a list of Input arguments which are all True by default. The fields that should be linked to the parent table are set to True. Other fields that do not need to be linked to a parent table can be set to False. In the DB query of a root table, only one field can be defined as True and it is populated by the Instance ID. |
Function Properties
The Function Properties tab displays the properties of either a source Root function or any Project function in the population.
Target LU Table Properties
 |
Population Object Name - displays the object name. Non-editable field. Table Name - displays the name of the target table. Non-editable. ID and Root Item ID - generated by Fabric. Mode - displays the Table Population mode. There are 4 modes: Insert (default) / Upsert / Update / Delete. Sync Method - displays the Table Population Sync method. There are 4 Sync methods: Inherited (default) / None / Time Interval / Decision Function. Truncate Before Sync - True / False. When Truncate Before Sync = True, the entire LU Table is truncated before the table population is executed. The Truncate Before Sync = True is equivalent to the All value in the Delete Mode LU table's property. Setting the Truncate Before Sync to True overrides the LU table's Delete Mode. When the Truncate Before Sync is set on False, the delete mode it taken from the LU table. Note that it is not recommended to set the Truncate Before Sync to True if the population mode is not Insert, since it truncates all records from the LU table before running the population. IID Finder - sets the IID Finder properties on a population level used when creating the IID Finder XML file. Open Table Schema - a link to the Table Schema window. |
Translation Properties
 |
Name - displays the function name. Non-editable. ID - generated by Fabric. Input Not Found Action - indicates the system’s behavior when a matching Translation is not found. There are 4 options: Use Default / Reject Record / Reject Instance / Report and Use Default. Is Import From SQL - False / True. Indicates whether the translation data was imported from SQL or not. Open Translation - a link to open the Translation window. Inputs Default Value - displays the Input parameters of the Translation. A default value can be defined for each Input field that can be used if there is no link connected to the field or when an Input value = Null. To remove the default value, right-click the field and select either Clear Value or Set as Empty String. |
Global Properties
 |
Name - displays the Global name. Non-editable. ID - generated by Fabric. Value - displays Global value. Non-editable. Comment - displays the Global's comment as populated in the globals definition. |
Constant Properties
 |
Name - displays the Constant name. Editable field. ID - generated by Fabric. Value - displays the Constant value. Editable field. |
Lookup Properties
Click for more information about Lookups properties.
Table Population Properties Tab
The Properties Tab in the Table Population window displays additional information about different objects in the Population window, as follows:
- DB query or Root function Source Objects.
- Target LU table.
- Other objects of a Table Population transformation like a Translation or Global.
- Properties of any selected field in a Population object.
Since each object has different properties, the tab’s layout is updated to display them when an object is selected in the map.
The properties include:
- Basic information about the Population object. For example, Name or ID.
- Specific properties of each object. For example, sync method of target LU table.
- Link to open the object. For example, to edit the query or the function.
- Input arguments (source only) or the Inputs default value, if applicable.
Source Object - DB Query Properties
|
Name - displays the DB query name. Editable field. ID - generated by Fabric. DB Connection - displays the DB interface of the Source Object. Non-editable. SQL - displays the query. To edit it, click the Edit Query link. Edit Query - a link to the Query Builder. Input Arguments - displays a list of Input arguments which are all True by default. The fields that should be linked to the parent table are set to True. Other fields that do not need to be linked to a parent table can be set to False. In the DB query of a root table, only one field can be defined as True and it is populated by the Instance ID. |
Function Properties
The Function Properties tab displays the properties of either a source Root function or any Project function in the population.
Target LU Table Properties
|
Population Object Name - displays the object name. Non-editable field. Table Name - displays the name of the target table. Non-editable. ID and Root Item ID - generated by Fabric. Mode - displays the Table Population mode. There are 4 modes: Insert (default) / Upsert / Update / Delete. Sync Method - displays the Table Population Sync method. There are 4 Sync methods: Inherited (default) / None / Time Interval / Decision Function. Truncate Before Sync - True / False. When Truncate Before Sync = True, the entire LU Table is truncated before the table population is executed. The Truncate Before Sync = True is equivalent to the All value in the Delete Mode LU table's property. Setting the Truncate Before Sync to True overrides the LU table's Delete Mode. When the Truncate Before Sync is set on False, the delete mode it taken from the LU table. Note that it is not recommended to set the Truncate Before Sync to True if the population mode is not Insert, since it truncates all records from the LU table before running the population. IID Finder - sets the IID Finder properties on a population level used when creating the IID Finder XML file. Open Table Schema - a link to the Table Schema window. |
Translation Properties
|
Name - displays the function name. Non-editable. ID - generated by Fabric. Input Not Found Action - indicates the system’s behavior when a matching Translation is not found. There are 4 options: Use Default / Reject Record / Reject Instance / Report and Use Default. Is Import From SQL - False / True. Indicates whether the translation data was imported from SQL or not. Open Translation - a link to open the Translation window. Inputs Default Value - displays the Input parameters of the Translation. A default value can be defined for each Input field that can be used if there is no link connected to the field or when an Input value = Null. To remove the default value, right-click the field and select either Clear Value or Set as Empty String. |
Global Properties
|
Name - displays the Global name. Non-editable. ID - generated by Fabric. Value - displays Global value. Non-editable. Comment - displays the Global's comment as populated in the globals definition. |
Constant Properties
|
Name - displays the Constant name. Editable field. ID - generated by Fabric. Value - displays the Constant value. Editable field. |
Lookup Properties
Click for more information about Lookups properties.
