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?
1048Post New Data Warehouse General Questions
What is the difference between junk dimension and degenerated dimension?
Explain what is a view as it relates to system modeling?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
Database in use is oracle?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
What is surrogate key? Where we use it explain with example?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What is data validation strategies for data mart v?
What is called data cleaning?
Explain what is partitioning? What are the types of partitioning?
What is the main difference between star and snowflake star schema? Which one is better and why?
Explain reference cursor?
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
Explain difference between e-r modeling and dimentional modeling?
What is the difference between constraind base load ordering and target load plan?