what is incremintal loading? 2.what is batch p

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

1.what is incremintal loading?
2.what is batch processing?
3.what is crass reference table?
4.what is aggregate fact table?

Incremental loading means loading the ongoing changes in the OLTP.

Aggregate table contains the [measure] values ,aggregated /grouped/summed up to some level of hirarchy.

(Continued on next question...)

Other Job Interview Questions

• How do you load the time dimension?
• What is VLDB?
• How do you load the time dimension?
• What type of Indexing mechanism do we need to use for a typical datawarehouse?
• What are non-additive facts?
• What is active data warehousing?
• What are the Different methods of loading Dimension tables?
• What is the difference between datawarehouse and BI?
• What are Data Marts?
• What does level of Granularity of a fact table signify?
• More...