What does level of granularity of a fact table signify?
What is many-to-many dimensional model in datawarehousing ?
Explain a linked cube?
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
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 datawarehousing?
What is the differences between star and snowflake schemas?
What are universe requirements?
Is there any difference in testing database and data ware housing?
Explain what are the different methods of loading dimension tables?
What is the purpose of Dataware Control?
What are parallel querys and query hints?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
Explain what are the basic needs to join two sources in a source qualifier?
For faster process, what we will do with the universe?