Advanced Tab - Advanced

The Advanced mode is used to define the order by providing exact order by expression to be used during record import. The expression should be a valid order by expression and is specific to a database.

In the staging table of 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.