Populating the Main Source LU Table - Logic
The Broadway flow of the main source LU table is generated based on the populationRootTable.pop.flow template. It deletes and repopulates the main source LU table under the following conditions:
When running an Extract task, regular Load task (the Data Versioning checkbox is clear) or Generate task.
If the Set Sync Policy task's setting is not set to Do not Sync From Source Data, a state that prevents synchronizing the entities from the source system.
Click to view the Override Sync Mode Summary Table.
The source LU tables are not populated by the LUI sync in the following cases:
- The Sync Policy is set to Do Not Sync From Source Data by the user.
- A delete only task.
- A reserve only task.
- A Data Versioning load task: the selected data version is copied from Fabric.
- Load synthetic entities tasks (the source environment name is Synthetic).
The Broadway flow also validates whether the entity exists in the source table. If the entity is not found in the main source tables, an exception is thrown and the entity is rejected.
The below image is an example of a Broadway flow that populates a main source LU table:
Populating the Main Source LU Table - Logic
The Broadway flow of the main source LU table is generated based on the populationRootTable.pop.flow template. It deletes and repopulates the main source LU table under the following conditions:
When running an Extract task, regular Load task (the Data Versioning checkbox is clear) or Generate task.
If the Set Sync Policy task's setting is not set to Do not Sync From Source Data, a state that prevents synchronizing the entities from the source system.
Click to view the Override Sync Mode Summary Table.
The source LU tables are not populated by the LUI sync in the following cases:
- The Sync Policy is set to Do Not Sync From Source Data by the user.
- A delete only task.
- A reserve only task.
- A Data Versioning load task: the selected data version is copied from Fabric.
- Load synthetic entities tasks (the source environment name is Synthetic).
The Broadway flow also validates whether the entity exists in the source table. If the entity is not found in the main source tables, an exception is thrown and the entity is rejected.
The below image is an example of a Broadway flow that populates a main source LU table:
