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