Change Capture Stage

This is not to be confused with the companion product IIS Websphere Change Data Capture

Change Capture Stage or Change Data Capture stage or CDC is used to capture the changes between the after_Data and before_data. 
Change Capture Stage

Change Capture Stage


Take Example Data as below 

Change_after_data 
e_id,e_name,e_add 
11,kim,syd 
22,jim,canb 
33,pim,syd 
44,lim,canb 
55,pom,perth 

Change_before_data 

e_id,e_name,e_add 
11,kim,syd 
22,jim,mel 
33,pim,perth 
44,lim,canb 
55,pom,adeliade 
66,shila,bris 

Take Job Design as below 
 


Read and load the data in two files as below 
 


In Change Capture Stage Select Key column as e_id 
and value column as e_add. Because e_add is the column we are going to update.

One thought on “Change Capture Stage

Leave a Reply

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