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 source qualifier?
What is the capacity of power cube?
Why facts table is useful in representing the data?
In document how to create metrics?
What is cost benefit analysis (cba)?
What is Discover and Execute in XMLA?
What is prompt types of prompts?use of prompts syntax of prompt?
Explain differences between star and snowflake schemas?
How can we schedule the graph in unix?
Explain hybrid slowly changing dimension?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
What is core dimension?