Interview Questions

What is Full load & Incremental or Refresh load?

ETL (extract, transform, and load) Testing Interview Questions


(Continued from previous question...)

3. 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

(Continued on next question...)

Other Interview Questions