Interested to Buy Any Domain ? << Click Here >> for more details...
where exactly in dataware house a confirmed dimension can
be created
- 4 Answers
- 12532 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
What is informatica architecture?
What is MODEL is Data mining world?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
Explain the hierarchies level data warehousing.
Explain the differences between normalizer and normalizer transformation?
What is scd1 , scd2 , scd3?
What function should we use to display the value entered or selected by a user in response to a prompt?
What is meant by metadata in context of a data warehouse?
What is static and local variable?
What is surrogate key? Explain with examples.
Explain what are conformed dimensions?
Can we have multiple application.cfm file in an application?
What are the different models used in cluster analysis?
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
