Data Warehousing Basics Question:
Download Job Interview Questions and Answers PDF
What is incremintal loading?
What is batch processing?
What is crass reference table?
What is aggregate fact table?
Answer:
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
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
Download Basics Data Warehouse Interview Questions And Answers
PDF
Previous Question | Next Question |
Suggest a good author for Hyperion in data warehousing? | What is the datatype of the surrogate key? |