Applying Column Transformation

A column transformation links the columns of a data source table to define an attribute of a logical entity or one of the parameters of a function transformation. The data source can be a configured connection of any defined physical model.
  1. Click the Browse tab on the Entity Transformation wizard.
  2. From the Attribute List, select the required attribute.
  3. Select the Column transformation type option.
    The Data source dropdown is displayed.
  4. Select the required Physical Model or Connection.
    Note: Every data source in the dropdown displays if it is a Connection or a Physical Model.
    The Table Name dropdown is displayed. It displays all the tables in the selected data source.
  5. Select the required table.
    The Column Name dropdown is displayed. It displays all the columns in the selected table.
  6. Select the column you want to map to the attribute.
    The selected column is mapped and these details are displayed below the attribute: <Physical model name><Table name>/<column name>.
    Note: The data type of the attribute is inherited from the mapped physical model column.
    Note: To delete the mapping, click corresponding to it. To cancel the updates made to this pop-up, click the Cancel button.
  7. Click OK.
    The mappings are displayed on the Create Mapping page.
  8. To save details, click Save on the Create Mapping page.