An LU schema structure displays a hierarchical representation of the 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 and each Table Population object, except the Table Population object of the Root LU table, must be linked to a parent table via its input arguments (input columns).
Each Table Population object can be linked to a different parent LU table.
For example: an ADDRESS LU table is populated by two populations:
Population 1, populates the customer’s billing address.
It is linked to the CUSTOMER table and selects source address records that belong to the CUSTOMER_ID.
Population 2, populates the the installation address of each subscription.
It is linked to the SUBSCRIBER table and selects the source address records that belong to the SUSBCRIBER_ID.
A link from a Table Population object to a parent LU table can be based on several columns where all columns must be linked to the same parent LU table.
Example 1:\ The INVOICE Table Population object can be linked to the BALANCE LU table by two columns: SUBSCRIBER_ID and BALANCE. This is a valid link.
Example 2:\ Linking the INVOICE Table Population object to two different LU tables - BALANCE and SUBSCRIBER is invalid.
Note: An LU table can be added to an LU schema without a Table Population object. This table is not populated by the sync of the instance, but can be populated by a separate transaction.
Input arguments are a property of the Source Object of a Table Population object.
There are two 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 which do not need to be linked to a parent table, can be set to False.
A link can be added in both directions:
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.
Note: Link all Input fields of the selected Table Population object to one parent table. A Table Population object cannot be linked to several parent tables.
Click the link and press the Delete key, or right click and select Delete.
An LU schema structure displays a hierarchical representation of the 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 and each Table Population object, except the Table Population object of the Root LU table, must be linked to a parent table via its input arguments (input columns).
Each Table Population object can be linked to a different parent LU table.
For example: an ADDRESS LU table is populated by two populations:
Population 1, populates the customer’s billing address.
It is linked to the CUSTOMER table and selects source address records that belong to the CUSTOMER_ID.
Population 2, populates the the installation address of each subscription.
It is linked to the SUBSCRIBER table and selects the source address records that belong to the SUSBCRIBER_ID.
A link from a Table Population object to a parent LU table can be based on several columns where all columns must be linked to the same parent LU table.
Example 1:\ The INVOICE Table Population object can be linked to the BALANCE LU table by two columns: SUBSCRIBER_ID and BALANCE. This is a valid link.
Example 2:\ Linking the INVOICE Table Population object to two different LU tables - BALANCE and SUBSCRIBER is invalid.
Note: An LU table can be added to an LU schema without a Table Population object. This table is not populated by the sync of the instance, but can be populated by a separate transaction.
Input arguments are a property of the Source Object of a Table Population object.
There are two 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 which do not need to be linked to a parent table, can be set to False.
A link can be added in both directions:
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.
Note: Link all Input fields of the selected Table Population object to one parent table. A Table Population object cannot be linked to several parent tables.
Click the link and press the Delete key, or right click and select Delete.