When replicating data, a very common requirement is to modify or 'transform' changed data before it reaches its final destination. Two simple examples:
-- Combine two columns of source data into a single value for a column at the target.
-- Change a numeric code at the source into a descriptive string for the target.
Many other transformations are possible, including those… Continue