Determine source to target field mapping - connect_cdc_sqdata - Latest

1. Determine which of the source fields/columns from the descriptions in step 1b are to be mapped to a target datastore(s). Note, if ALL source fields map to identically named target fields, I.E. this is a "Pure Replication" script and may be able to use the REPLICATE Command rather than require individual mapping procedures in step 5c.
2. Determine which of the source fields/columns from step 3a will move unchanged to the target fields derived in step 2b. These are the source fields that will be ‘straight mapped’ to the target fields.
3. Determine which of the remaining target fields derived in step 2b need to be mapped.
   1. Identify which functions will be required in order to map these target fields.
   2. Determine if any of the target fields require special processing.