Pages

Sunday 31 March 2019

Full Load vs. Incremental Load in Datawarehousing

Full Load vs. Incremental Load



Full Load:
Truncates all rows and loads from scratch.
Requires more time.
Can easily be guaranteed
Can be lost.



Incremental Load:
New records and updated ones are loaded.
Requires less time.
Difficult. ETL must check for new/updated rows.
Retained.

at

2 comments:

  1. Madhu17 April 2019 at 05:03

    Can you upload scd type-2 testing scenarios

    ReplyDelete
  2. Madhu17 April 2019 at 05:05

    How to test new inserted records and updates of existing records in incremental load

    ReplyDelete

Subscribe to: Post Comments (Atom)