September 29, 2012 \ Ananth TM \ 1 Comment 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 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.