9.17.2012

Full Load vs Incremental Load

Difference between Full Load and Incremental Load
S.No
Full Load
Incremental Load
1
Truncates all rows and loads from scratch.
New records and updated ones are loaded.

2
Requires more time.

Requires less time.

3
Can easily be guaranteed.

Difficult. ETL must check for new/updated rows.

4
Can be lost.
Retained.

No comments:

Post a Comment