Explain what is the difference between olap and datawarehosue?

Question Posted / murali

No Answer is Posted For this Question
Be the First to Post Answer

More Data Warehouse General Interview Questions

What is data warehouse architecture?

What are the data types present in bo?

What are the data types present in bo? What happens if we implement view in the designer n report?

What is meant by metadata in context of a data warehouse and how it is important?

Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?

Explain what is a three tier data warehouse?

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

Explain what are the steps to build the data warehouse?

Explain when do we analyze the tables? How do we do it?

why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.

What is is a star schema?

Explain what is a staging area? Do we need it? What is the purpose of a staging area?

For more Data Warehouse General Interview Questions Click Here