When should one use an MD-database (multi-dimensional database) and not a relational one?
IBM,
2 7722what is the difference between aggregate table and fact table ? how do you load these two tables ?
12 49563suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?
3 8742Post New Data Warehouse General Questions
Explain what are the methodologies of data warehousing?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
What is the 4 + 1 view model as it relates to system modeling?
How to pivot row data using informatica?
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
What are partition points?
Suppose we want to display zero when null values coming to report how can we do that?
Explain why denormalization is promoted in universe designing?
What are the approaches used by optimizer during execution plan?
How to limit the max no of rows retrieved in the report?
What is the purpose of cluster analysis in data warehousing?
How to add a number to a macro variable?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What are the other names given to 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?
