where exactly in dataware house a confirmed dimension can
be created
- 4 Answers
- 11320 Views
- Deloitte, I also Faced
- E-Mail Answers
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 the importance of data warehouse?
Explain what is the difference between powerplay transformer and power play reports?
Explain what is the main difference between inmon and kimball philosophies of data warehousing?
What is recovering sessions?
Code the tables statement for a single-level (most common) frequency?
What are the types of partitioning?
What are diagrams?
Explain is fact table?
Explain the main difference between inmon and kimball philosophies of data warehousing?
Explain a mapping, session, worklet, workflow, mapplet?
What are the advantages of query studio compared to report studio?
What are the main steps to build the data warehouse?
Is there any default username & pwd for bo designer & supervisor?
What is the very basic difference between data warehouse and operational databases?
Describe the differences between a data warehouse and data mart.
