Use the Column Mapping page to map output columns from your transformer to columns on your target table.
Columns that result from your transformation are listed on the left side of the page, under the heading "Source Columns". These columns are named after the selections you made for the Input column and the Period column on the Parameters page. For example, if you selected SALARY as the input column and Month for the period on the Parameters page, you will see "SALARY_Month" displayed on the left hand side of the Column Mapping page .
Columns in your target table are listed on the right side of the page.
Restrictions:
Because the calculate subtotal transformer can write to its source column, you can map an input column to itself. For example, you can map source column A to itself:
Source Column
Target Column
A
A
You can only map a column to itself as long as the column is not used as an input column in another transformer definition row. For example, you cannot map column A to itself if the following is true:
Source Column
Target Column
A_week
A_month
In this example, column A is used as an input column in two separate transformer definitions.
You cannot use a source column that is mapped to a target column as a target column in another mapping in the same step definition. For example, you have the columns B, C and D. Your first row is specified as follows:
Source Column
Target Column
B
C
Because column B is mapped as a source column, the following mapping is illegal:
Source Column
Target Column
D
B
After a column is mapped as a target, you cannot use the column as either an input column or a target output column in any other mappings in this step definition. For example, you have the following rows
Input Column
Output Column
A
A
B
C
Because you have specified Column A and Column C as output columns, you cannot use them as either input columns or output columns in any additional rows.
These restrictions apply to a single instance of a step. For example, you have step 1 and step 2. In step 1, you can use column B as a source column. In step 2, you can use column B as a target column.