Q: What is Change data Capture (CDC) in DataWareHousing?
Answer: Change data Capture will identify the Data in the Source System that has been modfied since last Extraction.
Example:
Suppose 11/07/2013 you have loaded your target table. so your last extraction date for the Source table is 11/07/2013. for te next load(11/08/2013) you want to load the target table again. so insted of pulling all the data from Source table we can extract the data newly Updated in Source System after 11/07/2013(Which is Last Extraction date). so that we will get all the records which will be Inserted newly/updated/Deleted in Source System. So that we will save the time insted of loading the entire target table again.
CDC will be Usefull when the Source table Containg Millions of Records.
Answer: Change data Capture will identify the Data in the Source System that has been modfied since last Extraction.
Example:
Suppose 11/07/2013 you have loaded your target table. so your last extraction date for the Source table is 11/07/2013. for te next load(11/08/2013) you want to load the target table again. so insted of pulling all the data from Source table we can extract the data newly Updated in Source System after 11/07/2013(Which is Last Extraction date). so that we will get all the records which will be Inserted newly/updated/Deleted in Source System. So that we will save the time insted of loading the entire target table again.
CDC will be Usefull when the Source table Containg Millions of Records.
No comments:
Post a Comment