Interested to Buy Any Domain ? << Click Here >> for more details...
where exactly in dataware house a confirmed dimension can
be created
- 4 Answers
- 12648 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
What is an error log table in informatica occurs and how to maintain it in mapping?
Explain what are the different methods of loading dimension tables?
Can we take backup when the database is opened?
Can you state some of the innovations throughout history?
What are the different methods of loading dimension tables?
What are the different problems that ?Data mining? can solve?
What are modeling tools available in the market?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Explain the hierarchies level data warehousing.
Why fact table is in a normal form?
What is "method/1"?
What is the difference between agglomerative and divisive hierarchical clustering?
What is the difference between filter and lookup transformation?
Explain what are data marts?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
