Interested to Buy Any Domain ? << Click Here >> for more details...
where exactly in dataware house a confirmed dimension can
be created
- 4 Answers
- 12848 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 grouped cross tab?
How to limit the max no of rows retrieved in the report?
Describe the differences between a data warehouse and data mart.
What is surrogate key? Explain with examples.
What are the possible data marts in retail sales?
What should I have in mind when building olap solution from scratch?
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
For faster process, what we will do with the universe?
What is the purpose of cluster analysis in data warehousing?
ware house management system is used?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What are the design methods of data warehousing?
What is the 4 + 1 view model as it relates to system modeling?
Explain differences between star and snowflake schemas?
What are session timeout and application timeout?
