ETL (Extract, transform, load) Question:
Download Questions PDF

Tell me what is Full load & Incremental or Refresh load?

Answer:

Full Load: completely erasing the contents of one or more tables and reloading with fresh data.

Incremental Load: applying ongoing changes to one or more tables based on a predefined schedule

Refresh Load: the table will be truncated and data will be loaded again. Here we use to load static dimension table or type tables using this method.
Incremental Load: It is a method to capture on the newly created or updated record. Based upon the falg or Date this load will be performed.
Full Load: when we are loading the data for first time, either it may be a base load or history all the set of records will be loaded at a strech depends upon the volume.

Download Extract, transform, load (ETL) Interview Questions And Answers PDF

Previous QuestionNext Question
Explain a mapping, session, worklet, workflow, mapplet?Explain What is a three tier data warehouse?