Data Compare Mapping

Map datasets and columns

Source to Target Mappings

There are three options for mapping datasets and columns from source to target.

1. When the table names and column names are same between source and target, they are automatically mapped.

2. User can explicitly edit the mapping by deleting or perform custom mapping. Steps to perform custom mapping are in the video below.

3. Upload Dataset/Column mapping file.

User can upload custom mapping file. This option is useful in the following scenarios.

• when the dataset names or column names are completely different .

• when user wants to map only certain datasets or columns.

The format of the csv file is

source_table_name	target_table_name	source_column_name	target_column_name	key_column

Download sample mapping file.

The CSV file should contain the following headers:

1. source_table_name: The name of the table in the source database.

2. target_table_name: The name of the table in the target database where the data is to be migrated or integrated.

3. source_column_name: The name of the column in the source table.

4. target_column_name: The name of the column in the target table that corresponds to the source column.

5. key_column: A flag (usually a boolean or similar indicator) to denote if the source column is a key column (primary key, foreign key, etc.). The value of key_column should be true/false.

Mapping file is case sensitive. Ensure the table names, and column names have the same case as in the database.

SQL Transformation

• SQL Transformation : This feature can be used to apply an SQL Transformation function for all the Source and Target columns. This can be helpful, for instance, if in one of the columns from either _Source _or Target the name has been written with uppercase, and the corresponding column from the other data source has the name in lowercase. The _SQL Transformation _can be used to write an SQL statement to change the column's names to uppercase. To do this:

  • Click on the icon under the SQL column.

  • Provide the SQL function in the Text Field and click on Done, or...

  • Slide the toggle and add predefined rules.

  • Go to Settings for Add New Rule functionality.

SQL Transformation

Tolerance

• Tolerance : Users can apply Tolerance for numeric (e.g., long, double, float, short, int.) , date and timestamp columns data types . Tolerance cannot be added to the key column.

  • Click on the icon under Tolerance.

  • Select the Operator and_ _type in the tolerance Value.

  • Click on Done.