satyaneerumalla

 Profile Answers by satyaneerumalla Questions by satyaneerumalla

• Sep 18th, 2006

 

Changed Data Capture (CDC) helps identify the data in the source system that has changed since the last extraction. With CDC, data extraction takes place at the same time the insert, update, or delete operations occur in the source tables, and the change data is stored inside the database in change tables. The change data, thus captured, is then made available to the target systems in a controlled manner.

mail me to discuss any thing related to informatica. it's my pleasure to discuss.

satya.neerumalla@tcs.com

calltomadhu

 Profile Answers by calltomadhu 

• Sep 22nd, 2006

 

CDC Changed Data Capture. Name itself saying that if any data is changed it will how to get the values. for this one we have type1 and type2 and type3 cdc's are there. depending upon our requirement we can fallow.

thanks

madhu

kusum

• Sep 27th, 2006

 

Whenever any source data is changed we need to capture it in the target system also this can be basically in 3 ways

Target record is completely replaced with new record(Type 1)

Complete changes can be captured as different records & stored in the target table(Type 2)

Only last change & present data can be captured (Type 3)

CDC can be done generally by using a timestamp or version key