What is confirmed dimension?
Answers were Sorted based on User's Feedback
Answer / ram
A Dimention table which can be shared by 2 or more fact
tables. for example time dimention which we can use in in
any fact table. is known as confirmed dimention
| Is This Answer Correct ? | 10 Yes | 4 No |
Answer / guest
a dimension which is shared by all fact tables that is
confirmed dimension.
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / pratap gangula
A confirmed dimension is a dimension which can be joined with more than one fact table and can be reused in other data marts as well.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / uma
an intermediate table(dummy table) to join 2 star schemas
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / raji
which is maintaining more than one fact table is called
confirm dimension. which is reusable dimension.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / santhosh kumar n
a dimension which can be shared by multople fact tables is
known as conformed dimension. this concept is from galaxy
schema.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ramjanaki
Confirmed Dimension is, which can be reusable across
multiple data marts.
| Is This Answer Correct ? | 3 Yes | 8 No |
Why is chameleon method used in data warehouse?
What is the difference between narmal load and bulk load?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
Is there any default username & pwd for bo designer & supervisor?
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
What is the difference between er modeling and dimensional modeling?
When should you use a STAR and when a SNOW-FLAKE schema?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
what is indexing ? what are different types of indexes supported by oracle ?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
What is Snow Flake Schema design in database?
What are the stages of datawarehousing?