where exactly in dataware house a confirmed dimension can
be created
- 4 Answers
- 11324 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 you set the session management?
Explain the definition of normalized and denormalized view?
Explain what is metadata reporter?
What are Non-additive facts?
What is prompt types of prompts?use of prompts syntax of prompt?
What is the purpose of Dataware Control?
What are necessary tasks to install reportnet software?
What is the difference between filter and lookup transformation?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What is many-to-many dimensional model in datawarehousing ?
a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron
How much data hold in one universe.
What is metadata in context of a datawarehouse and how it is important?
What is surrogate key? Where we use it? Explain with examples.
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
