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 |
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
wht is degenerated dimension ?it's uses?
What are the steps involved in designing a fact table?
Explain er diagram?
Explain is fact table?
What are aggregate fact tables ? why they are needed? give an example
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
what is parallelism?
How to get the first 100 rows from the flat file into the target?
Can you explain how analysis service works?
Explain Association algorithm in Data mining?
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?