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 |
List any five applications of data warehouse.
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?
What is the goal of optimizer?
Explain how to get the first 100 rows from the flat file into the target?
What is analytical or analytic mean?
Explain datawarehousing?
What is DTS ?
What is edw?
Where the data cube technology is used?
How to eliminate duplicate rows from flat file?
Fact table is in normalized or de-normalized form?
What is hash partition?