Data warehousing XMLA

NEXT>>

More Related Links

What is Data warehousing?

Answer - A data warehouse can be considered as a storage area where interest specific or relevant data........            

What are fact tables and dimension tables?

Answer - As mentioned, data in a warehouse comes from the transactions. Fact table in a data warehouse consists........

What is analysis service?

Answer - Analysis service provides a combined view of the data used in OLAP.........

Explain the difference between star and snowflake schemas.

Answer - A snow flake schema design is usually more complex than a start schema.....

What is the difference between view and materialized view?

Answer - A view is created by combining data from different tables........

What is a Cube and Linked Cube with reference to data warehouse?

Answer - A data cube stores data in a summarized version which helps in a faster analysis............

What are fundamental stages of Data Warehousing?

Answer - Stages of a data warehouse helps to find and understand.......