What are the different architecture of datawareh

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

(Continued from previous question...)

What are the different architecture of datawarehouse?

There are two main things

1. Top down - (bill Inmon)
2.Bottom up - (Ralph kimbol)

(Continued on next question...)

Other Job Interview Questions

• What is surrogate key ? where we use it expalin with examples
• What is the difference between ODS and OLTP?
• What is real time data-warehousing?
• What is Difference between E-R Modeling and Dimentional Modeling.?
• What is Fact table?
• What is data mining?
• What is hybrid slowly changing dimension?
• What is the difference between datawarehouse and BI?
• Why are OLTP database designs not generally a good idea for a Data Warehouse?
• What is surrogate key ? where we use it expalin with examples
• More...