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 |
Write a short note on data warehousing & three-Tier Warehouse architecture in detail.
Explain piconet?
What is difference between model & package?
Explain what is the difference between powerplay transformer and power play reports?
Explain the structure of cold fusion?
What is analytical or analytic mean?
Explain what are the different types of join operations?
What is a hash cluster?
OLAP architecture?
explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF ORACLE 8I
3 Answers IBM, Ness Technologies,
Difference between DSS & OLTP?
Define data warehouse?