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 |
What are the steps involved in creating dimensional modeling process?
Explain what is a cube in data warehousing concept?
Explain where do we use semi and non additive facts?
What is Data purging?
Explain what is the difference between stop and abort?
What is the difference between power center and power mart?
How can we load the time dimension?
What is defined as partial backup?
Tell me what is full load & incremental or refresh load?
Explain what is the difference between datawarehouse and bi?
What is the 4 + 1 view model as it relates to system modeling?
What is data warehouse architecture?