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
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
Explain what are data marts?
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?
Describe a data warehouse.
What is the difference between aggregate table and materialized view?
What is Operational Data Store?
Explain some of modeling tools available in the market?
Explain what are fact, dimension, and measure?
Explain the data type of the surrogate key?
Explain what is full load & incremental or refresh load?
How to stop a batch?
What are the possible data marts in retail sales?
Where we use surrogate key explain with example?
Explain the difference between data ware house & data mart?
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?