An LU schema structure displays a hierarchical presentation of data related to the Root Table. Parent-child links in LU tables are created via their Table Population objects :
Each LU table can have one or several Table Population objects. Each such object - except the Table Population object of the Root LU table - should be linked to a parent table via its input arguments.
Each Table Population object can be linked to a different parent LU table.
For instance: an ADDRESS LU table is populated with 2 populations:
A link from a Table Population object to a parent LU table can be based on several columns, all of which should be linked to the same parent LU table.
Note: An LU table can be added to an LU schema without a Table Population object. Such table is not populated by the sync of the instance, but rather by a separate transaction.
Input arguments of a population flow are defined by the PopulationArgs Actor's input argument that must be set to an External population type.
Each population flow should have at least one Input parameter. A Root table's population can have only one input argument, which is populated by the Instance ID.
Click for more information about population flows.
Click for more information about an Actor's input parameters.
Input arguments are a property of the Source Object of a Table Population object.
There are 2 types of Source Objects for a Table Population object:
DB Query
Root Function
Click for more information about Table Population Types.
When creating a DB query, by default all Input fields are set to True.
To edit an Input argument, do the following:
Click the source object of the Population window (the DB query) and verify that 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.
A link can be added in both directions:
You can link them by either dragging a connection line or by using the Tables Connection Assistance popup window, as follows:
Click the Population name of the child table.
Connect each input field to a parent table using one of the following methods:
Drag the connection line from this field into the parent table and column.
Click the parent table.
Connect each parent column to the child table population using one of the following methods:
Click the child table population header and drag a connection line between the parent table's column and the child table's input field.
Note: Link all the Input fields of the selected Table Population object to one parent table. A Table Population object cannot be linked to several parent tables.
In complex and large schemas, it is sometimes difficult to track the population link, from which table it comes and/or to which tables it goes. You can therefore click on the link and see it as an animated dashed line.
An LU schema structure displays a hierarchical presentation of data related to the Root Table. Parent-child links in LU tables are created via their Table Population objects :
Each LU table can have one or several Table Population objects. Each such object - except the Table Population object of the Root LU table - should be linked to a parent table via its input arguments.
Each Table Population object can be linked to a different parent LU table.
For instance: an ADDRESS LU table is populated with 2 populations:
A link from a Table Population object to a parent LU table can be based on several columns, all of which should be linked to the same parent LU table.
Note: An LU table can be added to an LU schema without a Table Population object. Such table is not populated by the sync of the instance, but rather by a separate transaction.
Input arguments of a population flow are defined by the PopulationArgs Actor's input argument that must be set to an External population type.
Each population flow should have at least one Input parameter. A Root table's population can have only one input argument, which is populated by the Instance ID.
Click for more information about population flows.
Click for more information about an Actor's input parameters.
Input arguments are a property of the Source Object of a Table Population object.
There are 2 types of Source Objects for a Table Population object:
DB Query
Root Function
Click for more information about Table Population Types.
When creating a DB query, by default all Input fields are set to True.
To edit an Input argument, do the following:
Click the source object of the Population window (the DB query) and verify that 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.
A link can be added in both directions:
You can link them by either dragging a connection line or by using the Tables Connection Assistance popup window, as follows:
Click the Population name of the child table.
Connect each input field to a parent table using one of the following methods:
Drag the connection line from this field into the parent table and column.
Click the parent table.
Connect each parent column to the child table population using one of the following methods:
Click the child table population header and drag a connection line between the parent table's column and the child table's input field.
Note: Link all the Input fields of the selected Table Population object to one parent table. A Table Population object cannot be linked to several parent tables.
In complex and large schemas, it is sometimes difficult to track the population link, from which table it comes and/or to which tables it goes. You can therefore click on the link and see it as an animated dashed line.