Hi,Please can u tell me..
What is the difference between a Hyperion Essbase CUBE and
a Star Schema?
Thanks in advance,
Vijay.
Answer / juff
Star schema fact table is surounded by all the dimension
tables.In Hyperion cube data values of fact table only
stored.
| Is This Answer Correct ? | 3 Yes | 0 No |
Explain differences between star and snowflake schemas?
what is parallelism?
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.
Briefly state different between data ware house & data mart?
Explain the definition of normalized and denormalized view and what are the differences between them?
What are data modeling and data mining?
What are Aggregate tables?
Explain normalization?
What is the difference between snowflake and star schema?
OLAP architecture?
How to drill through from a powerplay cube to reportnet?
Explain what is fact less fact table? Where you have used it in your project?