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.