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 are the main steps to build the data warehouse?
Where can one get more info about Data Warehousing?
Explain normalization?
What is many-to-many dimensional model in datawarehousing ?
How to pivot data using informatica when you have variable amount of pivot rows?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
Explain how are the dimension tables designed?
What is Time Series algorithm in data mining?
What is the difference between static cache and dynamic cache?
Name at least three brands of Database Management Systems
How many project sources we can create in metadata?
Whether dimension table can have numeric value?