Advanced Tab - Advanced

On the Advanced tab, you can define the exact Order By expression to be used during record import. The expression must be a valid Order By expression and is specific to a database.

In the staging table of TIBCO MDM, all attributes are of the type string, the data type conversion must be handled in the Order By expression. The data type conversion may vary for different type of databases. For example in case of Oracle database, TO_TIMESTAMP (CATTRA_TIMESTAMP,yyyy-MM-dd HH24:MI:SS.FF) DESC.

Advanced Tab for Big Data Import

When creating an input map, if you have selected the Big Data Import approval option, the Rulebase option is displayed on the Advanced tab.

Note: The Rulebase option is only supported for the input map with the Big Data Import approval option.

Browse to select the rulebase that is defined for the parent repository and of type Other. For information on creating a rulebase model and different types of rulebase types, see the "Creating a Rulebase Model" and "Actions Allowed for Different Types of Rulebases" sections in TIBCO MDM Studio Rulebase Designer User's Guide.