TDM DB - General Parameters

The TDM DB tdm_general_parameters table holds the following parameters:

• TDM Clean-up parameters that are automatically created in tdm_general_parameters by TDM DB creation scripts.

• LUI separator parameters. By default, the LUI separator is set to underscore. However, if the source entity ID contains an underscore, another separator must be set. For example, to enable the TDM process to parse the LUI correctly and to get the correct Customer ID, if the source Customer ID is 123_4, the LUI separator must not be an underscore.

  • The param_name of the LUI separator is iid_separator.
  • The param_value must be populated by the String set as a separator.

Note that the iid_separator setting impacts all LUs in a project.

Example:

Insert the following record to tdm_general_parameters to set the separator to @ :

insert into tdm_general_parameters (param_name, param_value) values ('iid_separator', '@');

The LUI of Customer 123_4 and environment ENV1 is ENV1@123_4.