Add the LU parameters to the LuParamsMapping MTable (located under the References section of the Project tree).
The LuParamsMapping has the following fields:
lu_name
param_name
lu_table
lu_table_field
description — this optional field allows adding a short description to the business parameters. The description is displayed in the task when hovering over a parameter, which helps users select business parameters for entity sub-setting.
Each parameter must be mapped to a field in an LU table. The parameter name does not need to match the lu_table_field name.
If you have calculated parameters, such as the number of open cases or an outstanding debt, you can create an LU table that contains these parameters. If created, these tables should be added to the TDMFilterOutTargetTables Actor in order to exclude them from the load and delete actions, as well as from the data generation flows.
Verify that all LU tables in LuParamsMapping are linked to their parent tables. This is required as a means to add FKs to tables when the latter are exported to the TDM DB.
Notes:
The TDM extract task execution exports LU tables into the TDM DB. A dedicated schema is created for each LU and an FK is created for each parent-child link between tables. The following tables are exported into the TDM DB:
FABRIC_TDM_ROOT — the entire table is exported.
TDM_BE_IIDS — the entire table is exported.
LU tables in LuParamsMapping MTable — only the parameter fields and the fields linked to the parent or child LU tables are exported.
PK and FK fields are exported.
The exported tables are used for:
The TDM task execution process populates the tdm_params_distinct_values table in the TDM DB with the parameters list and the valid values for combo parameters.
This table is used for getting the list of available parameters and their valid values in the task.
The AI-based generated entities are not synchronized from a data source. Instead, the AI process generates entities, which TDM then imports into Fabric. Afterwards, a post-TDM process updates the parameter tables for these imported entities, enabling their selection based on parameters.
Click here for more information about AI-based generation.
Notes:
<LU Name>_params
table in the TDM DB. The <LU Name>_params
table is required for both entity selection methods in a TDM task: Business parameters and Random selection.Add the LU parameters to the LuParamsMapping MTable (located under the References section of the Project tree).
The LuParamsMapping has the following fields:
lu_name
param_name
lu_table
lu_table_field
description — this optional field allows adding a short description to the business parameters. The description is displayed in the task when hovering over a parameter, which helps users select business parameters for entity sub-setting.
Each parameter must be mapped to a field in an LU table. The parameter name does not need to match the lu_table_field name.
If you have calculated parameters, such as the number of open cases or an outstanding debt, you can create an LU table that contains these parameters. If created, these tables should be added to the TDMFilterOutTargetTables Actor in order to exclude them from the load and delete actions, as well as from the data generation flows.
Verify that all LU tables in LuParamsMapping are linked to their parent tables. This is required as a means to add FKs to tables when the latter are exported to the TDM DB.
Notes:
The TDM extract task execution exports LU tables into the TDM DB. A dedicated schema is created for each LU and an FK is created for each parent-child link between tables. The following tables are exported into the TDM DB:
FABRIC_TDM_ROOT — the entire table is exported.
TDM_BE_IIDS — the entire table is exported.
LU tables in LuParamsMapping MTable — only the parameter fields and the fields linked to the parent or child LU tables are exported.
PK and FK fields are exported.
The exported tables are used for:
The TDM task execution process populates the tdm_params_distinct_values table in the TDM DB with the parameters list and the valid values for combo parameters.
This table is used for getting the list of available parameters and their valid values in the task.
The AI-based generated entities are not synchronized from a data source. Instead, the AI process generates entities, which TDM then imports into Fabric. Afterwards, a post-TDM process updates the parameter tables for these imported entities, enabling their selection based on parameters.
Click here for more information about AI-based generation.
Notes:
<LU Name>_params
table in the TDM DB. The <LU Name>_params
table is required for both entity selection methods in a TDM task: Business parameters and Random selection.