Change Apply stage

[mouniV]

Hi,

This question is regarding change apply stage. As I know change apply stage uses before data set and the difference data set (obtained from change capture stage) and generates after dataset.

If change capture stage already have the after data set to use to generate the difference dataset, why do we need to use this change apply stage again.

Can you pls brief any scenario where this change apply stage is required?

Thanks,
Mounika v

[kandyshandy]

Good question..

Change apply stage would be needed when you are working with datasets rather than databases (@ target). For database targets, you can directly apply the changes by using SQLs (inserts/updates/deletes).

Other uses may be
-> Just to reconcile
-> In some scenarios, you may just capture inserts (or edits) from after dataset & want to apply to before dataset

[mouniV]

Good question..

Change apply stage would be needed when you are working with datasets rather than databases (@ target). For database targets, you can directly apply the changes by using SQLs (inserts/updates/deletes).

Other uses may be
-> Just to reconcile
-> In some scenarios, you may just capture inserts (or edits) from after dataset & want to apply to before dataset

Thanks Kandy!! Got it..