TDM LU Implementation - General Guidelines

A TDM task copies a Business Entity (BE) from a source environment to a target environment. A BE can have multiple LUs with either a flat or a hierarchical structure. For instance, a Customer BE consists of Customer Care, Billing, Ordering and Usage LUs. The ability to break up a BE into several LUs enables maximum flexibility and avoids duplication of development. Additionally, defining a hierarchical structure of parent-child LUs enables creating LUs, based on the natural root entity of the related data sources, instead of forcefully setting unified root entities on all LUs related to a given BE.

Each LU in a TDM project should have additional components in order to support TDM functionalities, as described below:

Basic LU Structure

Each LU in a TDM project has the following structure:

  • Dummy root table, FABRIC_TDM_ROOT.

  • Generic TDM LU tables that are linked to the root table.

  • 2 main branches that are linked to the root table:

    • Source branch - LU tables that extract an entity's source data. Source LU tables are populated when a TDM task needs to load (insert) entities into a target environment and therefore must extract the source data of these entities.

    • Target branch - LU tables that extract the target keys of an entity. The keys are extracted from the target environment in order to enable deleting an entity from a target environment if required by the TDM task.

    Click for more information about Fabric implementation and deleting entities from the target environment.

Step 1 - Duplicate the TDM_LIBRARY LU into the New LU

Import the TDM_LIBRARY LU from the TDM Library to your project and duplicate it to the newly created LU (right click -> Duplicate Logical Unit). Now you have a template of the new LU with the TDM tables, including FABRIC_TDM_ROOT table as a root LU table.

Note that the LU_PARAMS table must be added to the LU schema although it is not required for defining LU parameters. In this case, the LU_PARAM table holds only the ENTITY_ID and SOURCE_ENVIRONMENT fields.

Step 2 - Add the Source LU Tables to the LU Schema

  1. Link the main source LU tables to the FABRIC_TDM_ROOT table. The main source tables represent the main (root) tables in the data source. For example, the Customer table is the main source LU table of the Customer LU.

  2. Verify that the main source LU tables are also populated in ROOT_TABLE_NAME and ROOT_COLUMN_NAME Globals.

  3. Create the population of the main source LU tables:

    Generate a Broadway flow for the LU table population based on populationRootTable.pop.flow template (imported from the TDM Library):

    • Right-click the table name > New Table Population Flow From Template > populationRootTable.pop.flow. A popup window opens.

    • Populate the popup window's settings as follows:

      • File Name - populate the file name by [LU Table Name].[flow name]
      • Parameters -
      • TABLE_NAME - populate it by the LU table name. Note that the LU table name should be identical to the data source table name.
      • KEY - populate the key to delete the LU table before populating it.
      • SOURCE_INTERFACE - the interface name for the source DB query.
    • Example:

      template

    • Right-click the table name > New Population . A popup window opens. Set the new population name and click Enter. Then select the populationRootTable.pop.flow template and populate its parameters:
      • TABLE_NAME - populate it by the LU table name. Note that the LU table name should be identical to the data source table name.
      • KEY - populate the key to delete the LU table before populating it.
      • SOURCE_INTERFACE - the interface name for the source DB query.
  4. Set the Truncate Before Sync property of the main source LU table to False, as the Broadway flow deletes the LU table before populating it.

  5. Link the remaining source LU tables to the main LU tables, in a way that if the main source LU table is not populated, the remaining source LU tables remain empty as well.

  6. Mask sensitive data in the LU tables by creating a Broadway flow with Masking Actors to populate the LU tables with the sensitive data.

    Click for more information about TDM Masking.

  7. Edit trnLuParams and LU_PARAMS in order to enable a subset of entities from selected parameters for this LU.

    Click for more information about Handling TDM Parameters.

Step 3 - Add the Target LU Tables to the LU Schema

  1. Define the LU tables in order to extract the target keys from the target environment. These keys are used by the delete flows for deleting an entity from the target.

  2. Link the main target LU table to the FABRIC_TDM_ROOT table.

  3. Add the fnDecisionDeleteFromTarget Decision function to all target LU tables. Note that this Decision function is under Shared Objects and is imported from the TDM Library.

  4. Create the population of the main target LU table based on a Broadway flow. The Broadway flow should set the task's target environment to be the active environment, enabling the selection of target IDs from the target environment.

  5. Link the remaining target LU tables to the main target LU table.

Click for more information about the deleting entities implementation.

Click for more information about deleting entities from a target environment using a TDM task.

LU Debug

The LUI should include the source environment, which should be set as the active environment in Fabric. When running a Data Viewer on the LU to debug its implementation, do either:

  • Populate the source environment of the LUI using _dev_. For example, _dev_1.
  • Create and deploy a source and target environments to the Fabric Debug server, set the source environment as an active environment in the Fabric Debug server and populate the deployed source environment name in the LUI, e.g., UAT_1. Note that the main target LU table sets the target environment to be the active environment.

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 re-populates the main source LU table under the following conditions:

  • Running an Extract task , regular Load task (the Data Versioning checkbox is cleared), or [Generate task].

  • The Set Sync Policy task's setting is not set to Do not Sync From Source Data in order to prevent 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 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.

See example of a Broadway flow that populates a main source LU table:

root example

Previous

TDM LU Implementation - General Guidelines

A TDM task copies a Business Entity (BE) from a source environment to a target environment. A BE can have multiple LUs with either a flat or a hierarchical structure. For instance, a Customer BE consists of Customer Care, Billing, Ordering and Usage LUs. The ability to break up a BE into several LUs enables maximum flexibility and avoids duplication of development. Additionally, defining a hierarchical structure of parent-child LUs enables creating LUs, based on the natural root entity of the related data sources, instead of forcefully setting unified root entities on all LUs related to a given BE.

Each LU in a TDM project should have additional components in order to support TDM functionalities, as described below:

Basic LU Structure

Each LU in a TDM project has the following structure:

  • Dummy root table, FABRIC_TDM_ROOT.

  • Generic TDM LU tables that are linked to the root table.

  • 2 main branches that are linked to the root table:

    • Source branch - LU tables that extract an entity's source data. Source LU tables are populated when a TDM task needs to load (insert) entities into a target environment and therefore must extract the source data of these entities.

    • Target branch - LU tables that extract the target keys of an entity. The keys are extracted from the target environment in order to enable deleting an entity from a target environment if required by the TDM task.

    Click for more information about Fabric implementation and deleting entities from the target environment.

Step 1 - Duplicate the TDM_LIBRARY LU into the New LU

Import the TDM_LIBRARY LU from the TDM Library to your project and duplicate it to the newly created LU (right click -> Duplicate Logical Unit). Now you have a template of the new LU with the TDM tables, including FABRIC_TDM_ROOT table as a root LU table.

Note that the LU_PARAMS table must be added to the LU schema although it is not required for defining LU parameters. In this case, the LU_PARAM table holds only the ENTITY_ID and SOURCE_ENVIRONMENT fields.

Step 2 - Add the Source LU Tables to the LU Schema

  1. Link the main source LU tables to the FABRIC_TDM_ROOT table. The main source tables represent the main (root) tables in the data source. For example, the Customer table is the main source LU table of the Customer LU.

  2. Verify that the main source LU tables are also populated in ROOT_TABLE_NAME and ROOT_COLUMN_NAME Globals.

  3. Create the population of the main source LU tables:

    Generate a Broadway flow for the LU table population based on populationRootTable.pop.flow template (imported from the TDM Library):

    • Right-click the table name > New Table Population Flow From Template > populationRootTable.pop.flow. A popup window opens.

    • Populate the popup window's settings as follows:

      • File Name - populate the file name by [LU Table Name].[flow name]
      • Parameters -
      • TABLE_NAME - populate it by the LU table name. Note that the LU table name should be identical to the data source table name.
      • KEY - populate the key to delete the LU table before populating it.
      • SOURCE_INTERFACE - the interface name for the source DB query.
    • Example:

      template

    • Right-click the table name > New Population . A popup window opens. Set the new population name and click Enter. Then select the populationRootTable.pop.flow template and populate its parameters:
      • TABLE_NAME - populate it by the LU table name. Note that the LU table name should be identical to the data source table name.
      • KEY - populate the key to delete the LU table before populating it.
      • SOURCE_INTERFACE - the interface name for the source DB query.
  4. Set the Truncate Before Sync property of the main source LU table to False, as the Broadway flow deletes the LU table before populating it.

  5. Link the remaining source LU tables to the main LU tables, in a way that if the main source LU table is not populated, the remaining source LU tables remain empty as well.

  6. Mask sensitive data in the LU tables by creating a Broadway flow with Masking Actors to populate the LU tables with the sensitive data.

    Click for more information about TDM Masking.

  7. Edit trnLuParams and LU_PARAMS in order to enable a subset of entities from selected parameters for this LU.

    Click for more information about Handling TDM Parameters.

Step 3 - Add the Target LU Tables to the LU Schema

  1. Define the LU tables in order to extract the target keys from the target environment. These keys are used by the delete flows for deleting an entity from the target.

  2. Link the main target LU table to the FABRIC_TDM_ROOT table.

  3. Add the fnDecisionDeleteFromTarget Decision function to all target LU tables. Note that this Decision function is under Shared Objects and is imported from the TDM Library.

  4. Create the population of the main target LU table based on a Broadway flow. The Broadway flow should set the task's target environment to be the active environment, enabling the selection of target IDs from the target environment.

  5. Link the remaining target LU tables to the main target LU table.

Click for more information about the deleting entities implementation.

Click for more information about deleting entities from a target environment using a TDM task.

LU Debug

The LUI should include the source environment, which should be set as the active environment in Fabric. When running a Data Viewer on the LU to debug its implementation, do either:

  • Populate the source environment of the LUI using _dev_. For example, _dev_1.
  • Create and deploy a source and target environments to the Fabric Debug server, set the source environment as an active environment in the Fabric Debug server and populate the deployed source environment name in the LUI, e.g., UAT_1. Note that the main target LU table sets the target environment to be the active environment.

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 re-populates the main source LU table under the following conditions:

  • Running an Extract task , regular Load task (the Data Versioning checkbox is cleared), or [Generate task].

  • The Set Sync Policy task's setting is not set to Do not Sync From Source Data in order to prevent 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 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.

See example of a Broadway flow that populates a main source LU table:

root example

Previous