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 Grain & Granularity in Data Warehouse.
Explain how to generate iqd file from framework manager?
Explain what are necessary tasks to install reportnet software?
what are different types of partitioning in oracle ?
What is conformed dimension?
Explain where do we use semi and non additive facts?
if we increase the number of dimensions will the rows in fact table increase or decrease??
what are different ways of loading data to data warehouse using oracle?
How to performance tune reports?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
Explain what is the difference between powerplay transformer and power play reports?
What is a functional dependency f said to be minimal?