Open the Sending or Receiving Properties dialog for the source table (using Properties from that table’s context menu). Accept the default selections on the Table tab.
On the Mapping tab, you define the column mappings for each of your target tables except the target whose mapping will be a duplicate, or reference to, an existing mapping.
-
From the Receiving server list, select the server to which one of your target tables belongs, then select the target table from the Receiving table list.
-
Click Defaults if all the columns are not already mapped. Review and complete the mapping of any unmapped columns: for example, on some targets in this exercise, the target column (CLIENT_NAME) has a corresponding source column (CUST_NAME), which must be manually selected from the Source Data list.
-
Click OK, then repeat these steps for the next target table.
Note the following:
-
Mapping long columns
Notice that the long column mappings do not differ from the other column mappings except that the DKey column is grayed out because one of the Distribution Key rules is that long columns cannot be Distribution Keys.
The Connect CDC Director permits you to map only the long columns that have supported datatypes that belong to the Connect CDC datatype categories Long Character, Long Binary, or Long Unicode. And you may not map datatypes from one category to datatypes of another.
-
Mapping by reference
A target to be mapped by reference requires no manual mapping at this stage. Its mapping will refer to and be a duplicate of one of the mappings you just defined. In this example, the mapping that will be referenced is the mapping from the source table to a nearly identical target table.