What is Full load & Incremental or Refresh load? - ETL

What is Full load & Incremental or Refresh load?

- Initial Load : It is the process of populating all the data warehousing tables for the very first time

- Full Load : While loading the data for the first time, all the set records are loaded at a stretch depending on the volume. It erases all the contents of tables and reloads with fresh data

- Incremental Load : Applying the dynamic changes as and when necessary in a specific period. The schedule is predefined each period