Every LU must include the capability to delete entities from the target environment in order to support the following tasks:
Note that if there is no need to support entity deletion or Data Versioning load tasks, the target tables do not have to be added to the LUs.
In the following scenarios, task execution is required to synchronize only the target tables, while preserving the source tables as they are:
Set the Sync method at the LU schema level to None as a way to support these scenarios. This ensures that the source LU tables are synced only once, except for when the task's Policy of fetching data field is set to All data from [source environment name]. However, the target LU tables are synced whenever the task deletes entities, as the target LU tables include a decision function that runs their population for such cases.
Click here for more information about task execution sync modes.
Each LU has two main branches linked to the FABRIC_TDM_ROOT table:
The target table contains the list of target IDs required for both deleting the data of selected entities from the target environment and populating the TDM_LU_TYPE_REL_TAR_EID table with the target children IDs. It is recommended to use the TAR_ prefix for each target table, as per the target table naming convention.
Generating target LU tables and delete flows is done automatically by the TDMLuInitBasedOnFabric flow when its CREATE_DELETE_TABLES input parameter is set to true. The names of these LU tables are controlled by the TDM_DELETE_TABLES_PREFIX shared Global, which uses TAR_ prefix by default. To change the prefix, update this shared Global and redeploy the LU before running the flow.
Target LU tables must be populated when running a TDM task that deletes entities from the target environment. The target keys are extracted from the target environment in order to enable the deletion of entities and their related data.
If the task does not delete entities from the target environment, extracting the target keys is not required.
The fnDecisionDeleteFromTarget decision function checks whether the task needs to delete entities from the target. When the task needs to delete entities from the target, the TDM_DELETE_BEFORE_LOAD Global is set to true by the Broadway InitiateTDMLoad flow (and to false otherwise). If the task needs to delete entities, the LUI sync process must repopulate all target IDs in the target LU tables for the entity deletion to occur.
For this reason, the fnDecisionDeleteFromTarget decision function (imported from the TDM Library) is automatically added to all target tables by the flow that generates them (the TDMLuInitBasedOnFabric flow).
The LUI sync process can populate the branches, source environment and target environment when running a load task that requires both entity deletion and loading operations.
The source LU tables must extract data from the source environment, whereas the target LU tables must extract data from the target environment.
The Broadway InitiateTDMLoad flow sets the active environment as the source environment before syncing the LUI into Fabric. The active environment must be changed to the target environment before starting the population of the LU table tables. Therefore, the setTargetEnv_Actor is added to the populated flow of the main target LU table to replace the active environment with the task's target environment (set in the TDM_TARGET_NEV_NAME key).
For example:
Note that target tables can be populated using the same interfaces as the source LU tables. Defining separate target interfaces is not required, since populating of the main target LU table sets the target environment as the active environment. As a result, the target tables use the target connection details during population.
Every LU must include the capability to delete entities from the target environment in order to support the following tasks:
Note that if there is no need to support entity deletion or Data Versioning load tasks, the target tables do not have to be added to the LUs.
In the following scenarios, task execution is required to synchronize only the target tables, while preserving the source tables as they are:
Set the Sync method at the LU schema level to None as a way to support these scenarios. This ensures that the source LU tables are synced only once, except for when the task's Policy of fetching data field is set to All data from [source environment name]. However, the target LU tables are synced whenever the task deletes entities, as the target LU tables include a decision function that runs their population for such cases.
Click here for more information about task execution sync modes.
Each LU has two main branches linked to the FABRIC_TDM_ROOT table:
The target table contains the list of target IDs required for both deleting the data of selected entities from the target environment and populating the TDM_LU_TYPE_REL_TAR_EID table with the target children IDs. It is recommended to use the TAR_ prefix for each target table, as per the target table naming convention.
Generating target LU tables and delete flows is done automatically by the TDMLuInitBasedOnFabric flow when its CREATE_DELETE_TABLES input parameter is set to true. The names of these LU tables are controlled by the TDM_DELETE_TABLES_PREFIX shared Global, which uses TAR_ prefix by default. To change the prefix, update this shared Global and redeploy the LU before running the flow.
Target LU tables must be populated when running a TDM task that deletes entities from the target environment. The target keys are extracted from the target environment in order to enable the deletion of entities and their related data.
If the task does not delete entities from the target environment, extracting the target keys is not required.
The fnDecisionDeleteFromTarget decision function checks whether the task needs to delete entities from the target. When the task needs to delete entities from the target, the TDM_DELETE_BEFORE_LOAD Global is set to true by the Broadway InitiateTDMLoad flow (and to false otherwise). If the task needs to delete entities, the LUI sync process must repopulate all target IDs in the target LU tables for the entity deletion to occur.
For this reason, the fnDecisionDeleteFromTarget decision function (imported from the TDM Library) is automatically added to all target tables by the flow that generates them (the TDMLuInitBasedOnFabric flow).
The LUI sync process can populate the branches, source environment and target environment when running a load task that requires both entity deletion and loading operations.
The source LU tables must extract data from the source environment, whereas the target LU tables must extract data from the target environment.
The Broadway InitiateTDMLoad flow sets the active environment as the source environment before syncing the LUI into Fabric. The active environment must be changed to the target environment before starting the population of the LU table tables. Therefore, the setTargetEnv_Actor is added to the populated flow of the main target LU table to replace the active environment with the task's target environment (set in the TDM_TARGET_NEV_NAME key).
For example:
Note that target tables can be populated using the same interfaces as the source LU tables. Defining separate target interfaces is not required, since populating of the main target LU table sets the target environment as the active environment. As a result, the target tables use the target connection details during population.