ETL (Extract, transform, load) Question:
Explain 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.
first time what we are loading the data is called initial load or full load.
secondtime or modified data waht ewe are loading is called as incremental load or delta load.
Incremental Load: applying ongoing changes to one or more tables based on a predefined schedule.
first time what we are loading the data is called initial load or full load.
secondtime or modified data waht ewe are loading is called as incremental load or delta load.
| Previous Question | Next Question |
| Explain What is a staging area? Do we need it? What is the purpose of a staging area? | Explain a mapping, session, worklet, workflow, mapplet? |