In jobs that include changed data capture transformations, the
source is a table that records changes to a database. Each row in the source changed data
table records an insert, update, or delete action. Each row includes the data that
was involved in the action.
The source changed data tables are generally created in native database format, using
technologies
that are provided by the database. The
CDC transformations require certain columns in the source changed data tables. The names
and order of the columns can vary. To identify the columns to the CDC transformations,
you specify option values in properties window.
The CDC transformations generate
target data that is suitable for loading into star schemas using the SCD Type 2 Loader transformation.