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 |
Tell me one example for multi valued dimension or bridge table?
2 Answers Accenture, CMC, IBM, Logica CMG, TCS,
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
What is the difference between view filter and report filter?
Explain the difference between data ware house & data mart?
What is the difference between constraind base load ordering and target load plan?
Where can one get more info about Data Warehousing?
How to join 3 database like flat file, oracle, db2 in informatrica?
What is Discover and Execute in XMLA?
2.What is staging area ?
4 Answers HCL, IBM, iFlex, TCS,
What is data stream and data adaopter?
Whether dimension table can have numeric value?
What is surrogate key?