Which CDC processing mode should you select?

HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package. The data source for
the data flow task is a table that has been configured as a change data capture (CDC) table.
You are using a CDC Source component to obtain the CDC data.
The CDC Source component has the following requirements:
The output must include metadata columns that indicate which source columns have
changed.
The output must return only one change row per source row that is modified in the current
CDC processing range.
You need to configure the CDC Source component.
Which CDC processing mode should you select? (To answer, configure the appropriate
option or options in the dialog box in the answer area.)

HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package. The data source for
the data flow task is a table that has been configured as a change data capture (CDC) table.
You are using a CDC Source component to obtain the CDC data.
The CDC Source component has the following requirements:
The output must include metadata columns that indicate which source columns have
changed.
The output must return only one change row per source row that is modified in the current
CDC processing range.
You need to configure the CDC Source component.
Which CDC processing mode should you select? (To answer, configure the appropriate
option or options in the dialog box in the answer area.)

Answer:



Leave a Reply 7

Your email address will not be published. Required fields are marked *


Jeff_Yen

Jeff_Yen

CDC Processing Mode

Select the processing mode that best handles your processing needs. The possible options are:
All: Returns the changes in the current CDC range without the Before Update values.

All with old values: Returns the changes in the current CDC processing range including the old values (Before Update). For each Update operation, there will be two rows, one with the before-update values and one with the after-update value.

Net: Returns only one change row per source row modified in the current CDC processing range. If a source row was updated multiple times, the combined change is produced (for example, insert+update is produced as a single update and update+delete is produced as a single delete). When working in Net change processing mode, it is possible to split the changes to Delete, Insert and Update outputs and handle them in parallel because the single source row appears in more than one output.

Net with update mask: This mode is similar to the regular Net mode but it also adds boolean columns with the name pattern __$__Changed that indicate changed columns in the current change row.

Net with merge: This mode is similar to the regular Net mode but with Insert and Update operations merged into a single Merge operation (UPSERT).

Jeff_Yen

Jeff_Yen

is the answer ‘Net with update mask’?

Islam

Islam

I think its net only or net with merge.

Islam

Islam

scratch that it should be net only due to the fact “The output must return only one change row per source row that is modified in the current
CDC processing range.”

And what jeff provided:

“Net: Returns only one change row per source row modified in the current CDC processing range. If a source row was updated multiple times, the combined change is produced (for example, insert+update is produced as a single update and update+delete is produced as a single delete). When working in Net change processing mode, it is possible to split the changes to Delete, Insert and Update outputs and handle them in parallel because the single source row appears in more than one output.”

ok

ok

is the answer ‘Net with update mask’?

Goofy

Goofy

The answer is C.
Net because one row per change row and update because of metadata columns.