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 types of partitioning?
Explain what are data marts?
How to create context?
What is the function of etl when used in data warehousing?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What are aggregate fact tables ? why they are needed? give an example
Explain in simple terms, the concept of Data Mining.
Explain about core dimension,
Database in use is oracle?
What is called data cleaning?
What are the advantages of query studio compared to report studio?
What Oracle features can be used to optimize my Warehouse system?