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 Bulk Insert?
Explain functional dependency?
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
Explain why dimenstion tables are denormalized in nature?
What is a staging area? Do we need it? What is the purpose of a staging area?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
What are the advantages and disadvantages of reporting directly against the database?
What is vldb(very large databases)?
What is the difference between a data warehouse and a data mart?
15 Answers Apex, ASD Lab, Bank Of America,
Explain about core dimension,
How to create prompts in report net?
What are cursors?