Interested to Buy Any Domain ? << Click Here >> for more details...
where exactly in dataware house a confirmed dimension can
be created
- 4 Answers
- 12603 Views
- Deloitte, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / prodyot sarkar
This dimensions are something that is built once in your model and can be reused multiple times with different fact tables. For example consider a model containing multiple fact tables representing different data marts. Now look for a dimension that is common to these facts tables. In this example let’s consider that the product dimension is common and hence can be reused by creating short cuts and joining the different fact tables.Some of the examples are time dimension customer dimensions product dimension.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / sri
conformed dimensions can be created in data staging area as
flat files ready to export.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / dipti a
Conformed Dimension is the dimension table which is shared between 2 or more fact table. From reusability perspective its very important. Such type of dimensions one can see it in Galaxy schema / fact constellation schema.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain about core dimension, balanced dimension, and dirty dimension?
What is an error log table in informatica occurs and how to maintain it in mapping?
How to generate the cubes in framework manager?
What is a cube in data warehousing concept?
How to join 3 database like flat file, oracle, db2 in informatrica?
Explain the difference between data ware house & data mart?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
what are the types of dimension tables
What is the "junk dimension"? Give with examples?
what type of raid setup would you put your tx logs?
what are different ways of loading data to data warehouse using oracle?
Can we have multiple application.cfm file in an application?
Teradata 
