Tell me one example for multi valued dimension or bridge
table?
Answer Posted / jenny
Bridge table is good when you have to change Many-to-Many
relationshipes to two one-to-many relationships.
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
What is latest version of power center / power mart?
Explain what is analytical or analytic mean?
What is the differences between star and snowflake schemas?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
Explain what is the difference between view filter and report filter?
Explain what are non-additive facts in detail?
Fact table is in normalized or de-normalized form?
Explain dimensional modelling?
Why denormalization is promoted in universe designing?
Can we start and stop single session in concurent bstch?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
Explain conformed fact?
What are the different methods of loading dimension tables?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?