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 CDC
transformations generate target data that is suitable for loading
into star schemas using the SCD Type 2 Loader transformation.
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 following columns can vary. To
identify the columns to the CDC transformations, you specify option
values in properties window.
The CDC
transformations require the following column definitions in the source
changed data tables:
identifies the application
that compares the source change data records to the records in the
target to test for previous updates. A typical value for this column
is SAS Data Integration Studio. The
column type is character and the length is 64.
identifies the source
changed data table. The column type is character and the length is
64.
provides the unique
identifiers in the target that are not to be overwritten. The column
type is numeric and the length is 8. For the Oracle CDC transformation,
the length is 32.
records the number
of source changed data records that were processed the last time that
the job was run. The type of this column is numeric and the length
is 8.
identifies the time
and date when the job was run. The type of this column is numeric
and the length is 8.