Interested to Buy Any Domain ? << Click Here >> for more details...
where exactly in dataware house a confirmed dimension can
be created
- 4 Answers
- 12710 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 are the different types of join operations?
What is the difference between drill through and masterdetail reports?
What are the key features of chameleon that separates it from other algorithms?
Explain how to export mappings to the production environment?
Give some difference between oltp and olap.
Explain what is a three tier data warehouse?
Explain difference between e-r modeling and dimentional modeling?
How to create diff. Types of templates?
What is a relationship?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
What are the data types present in bo?
What are session timeout and application timeout?
What is prompt types of prompts?use of prompts syntax of prompt?
Explain what is real time data-warehousing?
Explain some of modeling tools available in the market?
