Mapping source columns to target columns

You can manually map any remaining target columns remaining unmapped by the Map Table wizard, so that they are populated with data during replication activities. For example, certain target columns may have remained unmapped by the Map Tables wizard if the column names between the source and target tables did not match, or if the data types between columns are not compatible.

1. Click Configuration > Subscriptions.
2. Select the subscription.
3. Click the Table Mappings view and select the table mapping from the Source Table column.
4. Right-click and select Open Details....

   You may see target columns that are not mapped to any source columns. These target columns are mapped with an initial default value such as BLANK, CURRENT DATE, NULL, and so on.

5. Click the Column Mappings tab.
6. Expand the Source Columns list and select a source column.
7. Ensure that the data types are compatible by enabling the Show Column Data Types check box.

   You can map source columns to target columns only if the data types between both are compatible.

8. Drag and drop the source column to the Source area to map it to a target column.
9. Click Save.

   A check mark () displays next to any source column that is mapped to a target column. When you start replication on the subscription, CDC Replication populates the target column with data from the source column.