Data Warehousing Basics Interview Question:

What is incremintal loading?
What is batch processing?
What is crass reference table?
What is aggregate fact table?

Submitted by: Administrator

Incremental loading means loading the ongoing changes in the OLTP.<br><br>Aggregate table contains the [measure] values ,aggregated /grouped/summed up to some level of hirarchy.<br>

Batch Processing means executing more than one session in single run at the same time. we can execute these session in 2 ways : <br>linear: exececuting one after another<br>parralel: executing more than one session at at time
Submitted by: Administrator