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 datawarehousing?
What are the different types of scd's used in data warehousing?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
Explain the difference between dw and bi?
What is the main difference between schema in rdbms and schemas in datawarehouse?
Explain about core dimension, balanced dimension, and dirty dimension?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
Store (and count) non-fact records?
Explain is fact table?
What is degenerate dimension table?
Explain dimensional modelling?
Why is dimensional normalization not required?