What is the difference between datawarehouse and

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

(Continued from previous question...)

What is the difference between datawarehouse and BI?

Simply speaking, BI is the capability of analyzing the data of a datawarehouse in advantage of that business. A BI tool analyzes the data of a datawarehouse and to come into some business decision depending on the result of the analysis.

(Continued on next question...)

Other Job Interview Questions

• Can a dimension table contains numeric values?
• What are non-additive facts?
• Difference between Snow flake and Star Schema. What are situations where Snow flake Schema is better than Star Schema to use and when the opposite is true?
• What is aggregate table and aggregate fact table ... any examples of both?
• Why fact table is in normal form?
• What is Data warehosuing Hierarchy?
• What is aggregate table and aggregate fact table ... any examples of both?
• Why should you put your data warehouse on a different system than your OLTP system?
• What is meant by metadata in context of a Datawarehouse and how it is important?
• What is data mining?
• More...