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
What is the use of incremental aggregation? Explain me in brief with an example?
Explain which columns go to the fact table and which columns go the dimension table?
What is data type of the surrogate key?
What are the different types of schemas used in data warehousing?
What are fundamental stages of data warehousing?
Explain the differences between normalizer and normalizer transformation?
Explain a mapping, session, worklet, workflow, mapplet?
Give some difference between oltp and olap.
Explain me what is vldb?
What is operational data store (ods)?
Start a batches with in a batch?
How to generate iqd file from framework manager?
Difference between PowerPlay transformer and power play reports?
Can we have multiple application.cfm file in an application?
Where the applications and where