explain about balanced dimension,



explain about balanced dimension,..

Answer / Hemendra Singh

A Balanced Dimension is a type of dimensional modeling where all facts are stored at the same level of granularity. In other words, every fact table is joined to the same dimension tables and there are no aggregate or summary tables. This ensures that queries can be run at any level of detail without having to join multiple aggregated tables.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Warehouse General Interview Questions

Write a short note on data warehousing & three-Tier Warehouse architecture in detail.

1 Answers  


Explain piconet?

1 Answers  


What is difference between model & package?

1 Answers  


Explain what is the difference between powerplay transformer and power play reports?

1 Answers  


Explain the structure of cold fusion?

1 Answers  


What is analytical or analytic mean?

1 Answers  


Explain what are the different types of join operations?

1 Answers  


What is a hash cluster?

1 Answers  


OLAP architecture?

1 Answers   CTS, Honeywell,


explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF ORACLE 8I

3 Answers   IBM, Ness Technologies,


Difference between DSS & OLTP?

6 Answers   IBM,


Define data warehouse?

1 Answers  


Categories