What is the difference between OLAP and dataware

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

(Continued from previous question...)

What is the difference between OLAP and datawarehosue?

Datawarehouse is the place where the data is stored for analyzing
where as OLAP is the process of analyzing the data,managing aggregations,
partitioning information into cubes for indepth visualization.

(Continued on next question...)

Other Job Interview Questions

• What is a linked cube?
• What is the main difference between Inmon and Kimball philosophies of data warehousing?
• Why is Data Modeling Important?
• What is the difference between ODS and OLTP?
• what is the datatype of the surrgate key ?
• How do you load the time dimension?
• What is aggregate table and aggregate fact table ... any examples of both?
• What is Dimensional Modelling? Why is it important ?
• Which columns go to the fact table and which columns go the dimension table?
• What is meant by metadata in context of a Datawarehouse and how it is important?
• More...