where exactly in dataware house a confirmed dimension can
be created
Answer Posted / sandeep.pamarati
A confirmed Dimension, by definition, means a single
dimension table is actually connected to more than one fact
table in your dimensional model.
So, if a dimension table is shared across two fact tables,
for example, then that dimension is called as Conformed
Dimension.
PS: It is NOT Confirmed Dimension but it is Conformed Dimension.
| Is This Answer Correct ? | 15 Yes | 5 No |
Post New Answer View All Answers
Explain about core dimension, balanced dimension, and dirty dimension?
Difference between cold fusion mx 6 and cold fusion mx 7?
What is drilling across?
How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?
What is the difference between view filter and report filter?
What is bi?
What is the difference between datawarehouse and bi?
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?
How to limit the max no of rows retrieved in the report?
what type of raid setup would you put your tx logs?
How to drill through from a powerplay cube to reportnet?
How many types of facts and what are they?
Explain what is the difference between power center & power mart?
What is called dimensional modelling?
What is difference macros and prompts?