where exactly in dataware house a confirmed dimension can
be created
- 4 Answers
- 11337 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
Explain what are the modules in power mart?
What is batch processing?
How to calculate fact table granularity?
Explain what is analytical or analytic mean?
what are the different views that are considered when building an object-oriented software system?
The same tier?
What is metadata in context of a datawarehouse and how it is important?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
How to load the time dimension?
Why is business intelligence (bi) important in data warehousing?
What is the data type of the surrogate key?
What are components of reportnet?
Name a few sectors which use data warehousing?
Explain the main differences between star and snowflake schema?
How much data hold in one universe.
