What is Change Data Capture(CDC) or delta data? what is Refresh load?

Change Data Capture is a design which is used to Capture only those data which are newly inserted/updated in Source from previous read.
Mostly we achieved this by maintaining Date or Flag in Source Table to indicate inserted/updated status.

Ex:if suppose in first run  we have 10 records and these records are loaded into target.before starting second run we have 3 records updated among 10 previous records and 5 new records are interested.so here i want process the data what ever newly inserted/update after the first run. 

Refresh load:
Refresh load - Where the existing data is truncated and reloaded completely.

Thanks

Ur's Hari

If you like this post, please share it by clicking on g+1 Button.