Tell me one example for multi valued dimension or bridge
table?
Answers were Sorted based on User's Feedback
Answer / sudheer.r
bridge table nothig but its a multipart key ..
bridge table maintain relation ship between fact table and
dimension table . at the time of having multiple key
values,that table calls bridge table
| Is This Answer Correct ? | 10 Yes | 2 No |
Answer / 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 |
What are the different types of data warehouses?
What is the 4 + 1 view model as it relates to system modeling?
Explain how to export mappings to the production environment?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
What is data type of the surrogate key?
What is the main difference between inmon and kimball philosophies of data warehousing?
Explain what is partitioning? What are the types of partitioning?
Explain what is the difference between olap and datawarehosue?
What is an error log table in informatica occurs and how to maintain it in mapping?
Explain why should you put your data warehouse on a different system than your oltp system?
What are the reasons to use a chameleon method in data warehousing?
where exactly in dataware house a confirmed dimension can be created