Map at the column level

For details on mapping at the column level, see this video:

Note:

Make sure you mapped at the table level before you map at the column level, Map at the table level.

1. In the Target Tables pane, select the target table, then click the Map Column icon.
2. (Optional) Select one or more target columns, then select Automap Selected Columns from the Map drop-down. The system suggests mappings to matching source columns, if any.
3. Select one or more source columns to map to a single target column, select the target column, and click the Map icon in the target column's row.
4. To write an expression operating on the target column data as part of the Select clause, do one of the following:

   • Enter free text either in the Expressions field, using normal SQL syntax (without curly brackets).

     Important:

     • If you reference a static package or function in free text, you must select it in the Selected Packages tab.

     • In free text, use just the column name, not the table.column format, unless you need to use an alias, as in a self-join. In that case the alias.column format is required.

     • Create table aliases in the Mapped Sources tab to use in free text expressions.

   • Click the Add or Modify Expression icon to Use the Expression Builder that generates code using curly brackets.

     Important:

     Only one syntax style can be supported in a single table mapping.

5. If you create a Many-to-1 column mapping, you must select one of the source columns as the preferred path in the Mapped Sources tab.
6. Continue until all columns are either mapped or marked as Not Used.
7. Save.
8. From the Install drop-down, select either Install or Full Install. See Install a transformation.

To run the transformation, go to Study Manager.