Difference
between Full Load and Incremental Load
S.No Full LoadIncremental Load1Truncates 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