What is data warehosuing hierarchy?



What is data warehosuing hierarchy?..

Answer / Arun Chaurasiya

Data warehousing hierarchy refers to the organization of data in a data warehouse. The hierarchy consists of multiple levels, with each level representing different granularity of data. At the bottom level, the fact tables store detailed transactional data, while at higher levels, summarized aggregate facts are stored. Dimension tables, which contain descriptive attributes about the data, support the fact tables and facilitate querying and reporting.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Warehouse General Interview Questions

Difference between PowerPlay transformer and power play reports?

1 Answers   CTS,


What is a cube in data warehousing concept?

1 Answers  


Who needs data warehousing?

1 Answers  


how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause

1 Answers   iGate,


What are the methodologies of data warehousing?

1 Answers  


How do you create surrogate key using ab initio?

1 Answers  


What is Drill by? drill through?

1 Answers   CMC, iFlex,


What is the main difference between inmon and kimball philosophies of data warehousing?

1 Answers  


What is data warehosuing hierarchy?

1 Answers  


what is difference between Independent Data Mart Dependent Data Mart 1- 1- 2- 2- 3- 3- 4- 4-

4 Answers  


Explain the differences between normalizer and normalizer transformation?

1 Answers  


Explain what is metadata reporter?

1 Answers  


Categories