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 data cleaning? How can we do that?
Explain difference between data ware house & data mart?
5.Explain ODS ?
What is data merging, data cleansing and sampling?
What are cluster analysis in data warehousing?
Difference between ODS and Staging
Explain what is the data type of the surrogate key?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
What is Molap and Rolap? What is Diff between Them?
What should I have in mind when building olap solution from scratch?
suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?
What Oracle tools can be used to design and build a W/H?