Column Mapping to a new Target Table
When a transformation has a new table as a target, you can add, remove, and change the order of the columns from the target table before creating it.
Note:
When the source is a SQL Statement rather than a table, the column mapper does not allow you to modify columns. In the case where the source is a SQL Statement, the columns and their order are determined by the SQL Statement.
Adding a Derived Column
In order to add a column to the target table, you must first add a row to the list of columns.
1. Click the Add Row button.
The column mapper will create an empty row at the top of the list.
2. Fill in the appropriate values for Source Column, Target Column, Data Type, Length, Precision and Scale.
For example, if you have a source that is an expression where 1 is added to the value a field called ordercount, the new column in the target table will be adjustedOrderCount. adjustedOrderCount has a data type of NUMERIC with a length of 19 and a precision of 20. Once the new column has been defined, you can use the up and down arrows to position it in the desired location.
Deleting a Row
You can remove a column from the metadata of the target table. To do that, you must delete the row from the column mapper. To delete a row, click the delete button on the right edge of the row.
CAUTION:
It is important to avoid deleting columns that might be a unique key, as Incremental synchronization depends on having a unique key.