What is conformed dimension?
Answers were Sorted based on User's Feedback
Answer / venky chowdary
A Dimension Table Which can be shared by multiple Fact Tables called confirmed Dimension..
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / 19-10-2011
THE DIMENSION IS USED BY TWO FACT TABLES IS CALLED AS
CONFORMED DIMENSION.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / sunil pandey
The dimension which is shared by all star schema or more than one star schema and it's structural definition should be same.
eg:- like product this is one dimension and it's pid is same in two star schema(orders & productions).so it will bshared across them.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / sunil.hit
Confirmed dimension are those type of dimension whose...name fields,
and property remains same, throughout data warehouse.
| Is This Answer Correct ? | 1 Yes | 1 No |
What is prompt types of prompts?use of prompts syntax of prompt?
What is a source qualifier?
Why should you put your data warehouse on a different system than your oltp system?
What we will do with the universe for faster process?
Explain which are the olap tools available that are supported by oracle?
Where do we use semi and non additive facts?
What is a full backup?
What are situations where snowflake schema is better than star schema when the opposite is true?
What is partitioning? What are the types of partitioning?
How can we do data cleaning?
What is core dimension?
Where we use surrogate key explain with example?