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 is Analysis Services?
Explain when do we analyze the tables? How do we do it?
What is surrogate key? Where we use it?
Explain where do we use semi and non additive facts?
Whether dimension table can have numeric value?
How to pivot row data using informatica?
Where the applications and where ware house management system is used?
What are data modeling and data mining? Where it will be used?
Explain the difference between filter and conditin?
in siebel analytics by using dashboard prompts in a page have 2 reports so i have to give dashboard prompt to applied on first report only that will not applied to 2 report how it will do
What are Non-additive facts?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?