Create a side transformation

Work on one side transformation at a time, then merge it into the main transformation, and delete the side model.

1. Check out the transformation if it is not already checked out.
2. In the Target Tables pane of the Transformation tab, select the target table(s) you want to work on. Use Ctrl+click or Shift+click to select multiple tables.

   Tips:

   A target table can be in only one side model at a time. An icon next to the table name indicates a table already in a side model. Hover over the icon to see who is working on it.

   You can select a table marked Not Used. It is marked Used when you merge back to the main transformation.

3. Click the Create Side Model icon. You may need to click the >> icon to see it. It is not enabled until you select a table.
4. Enter a name for the side model. Do not use the string $TEMP.
5. Click OK.
6. Select one or more source tables, then select the target table, and then click the Map icon in the target table's row.

   You can Use Automap before or after mapping manually.

7. Select a Transformation Type: Direct, Join, Union, Pivot, Unpivot, or Custom.

   Tip:

   Even if you are using a custom program, select the actual type of transformation your program performs: Direct, Join, Union, Pivot, or Unpivot. Use Custom only if your program cannot support data lineage tracing.
8. Map the target table and columns; see Map at the table level and Map at the column level.
9. (Optional) Cascade blinding or define tables and columns as Not Used. When the side transformation is merged back into the main transformation, the blinding and Not Used attributes are applied to the tables in the main transformation.

   Any validation checks or custom listings dependent on tables or columns marked as Not Used are disabled when the side transformation is merged with the main transformation.

10. Check In the side model.

    Tip:

    You can now run the side transformation from the Study Manager without affecting the main transformation. You can see data in the target tables on the Listings page.

Next: Merge a side transformation with the main transformation.