Friday, 31 August 2012

Extracting and Loading Mechanism in DAC

DAC supports different kind of data extraction and loading combinations to give more flexibility over the kind of data transformation that happens.
Full Extract and Full Load: Loading of data warehouse first time happens in this way
Full Extract and Incremental Load: This comes in a situation like when you have to pull data from a new source and load it into the existing table in warehouse. It will have an additional logic whether to insert/update the record in cases of handling data integrity.
Incremental Extract and Incremental Load: This would be the regular process where the data loading happens every night which captures only the new or changed records.

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...