Mapping activity

With the Mapping activity, you can map source properties with target table columns, regardless of name differences. In this way, you can define tables with custom column names and map them to any data object properties. This facilitates the creation of adaptable data structures that are independent of schema requirements. By reusing familiar column naming conventions, you can maintain existing query workloads with minimal adjustments. The Mapping activity also supports automatic column mapping based on exact or partial matches, and includes advanced features such as searching, sorting, filtering, validating, and managing changes.

You can add the Mapping activity to the model by dragging the Transformation category from the activity bar or by selecting a position in the model. When you click an empty activity position on the canvas, the Activity Catalog is displayed and you can select the needed activity.

To configure the Mapping activity, perform these steps:

  1. Click the Mapping activity to expand the right panel.
  2. On the panel, perform one of these actions:
    • To automatically assign table columns to unmapped properties based on exact or partial name matches, click Auto-map.
    • To manually map the properties, click the table Name column and select the needed column from the displayed list or perform a search for the column in that list.

    You can use the column sorting and filtering options.

    To clear all selected table columns from the mapped properties, click the Eraser icon. To clear a single selected table column, click its name and select a blank field in the displayed list.

    The mapping is validated and information about the number of successfully mapped properties and properties with a warning or error is displayed. At the property level, these status icons are displayed in the Status column:

    • Success icon: The property has a valid mapping. The object properties in the Data Catalog match the data types in the corresponding destination table columns.
    • Warning icon: The property has an incorrect data type mapping. This indicates a mismatch between the Data Catalog object properties and the data types in the corresponding destination table columns. You can run the pipeline but, depending on the data type mismatch, inserting records into the database can be prevented.
    • Error icon: The property is not mapped because the destination table column is not selected. You cannot run the pipeline.
  3. To close the panel, click Close.
  4. Click Save.