Full Load(or Initial load): Full load is to reload all the data from scratch. In this it truncates all the records loaded before and loads the data from scratch.
Incremental Load(or Delta load): Unlike Full load(truncating and loading the data from scratch), only new and updated records are loaded.
Differences:
Full Load truncates all the rows and loads from scratch whereas Incremental load loads only the new and updated records
Full load takes more time when compared to incremental load
Full is easy when compared to Incremental load because in Incremental load ETL must check for updated records
No comments:
Post a Comment