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 approaches used by optimizer during execution plan?
What is DTS ?
Explain why denormalization is promoted in universe designing?
what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc
What is Grain & Granularity in Data Warehouse.
What is a star schema? Why does one design this way?
What is surrogate key? Where we use it?
What is the difference between a W/H and an OLTP application?
What are the advantages and disadvantages of reporting directly against the database?
What is meant by metadata in context of a data warehouse and how it is important?
What needs to be done when the database is shutdown?
What is loop in data warehousing?