Hello
We are currently working on dimension modeling for healthcare project. We come across many bridge tables in OLTP DB. What is the best approach while designing dimensional modeling for bridge tables. Right now we are joining provider and provider_category_type via provider_category. My only concern is will there be any performance impact of too many bridge tables(many-many) in ssas cube.
Eg.,
Provider
Provider_Cegory (Bridge Table) Many-many
Provider Category Type
Provider
Provider_Identifier (Bridge Table) Many-many
Prvider Identifier Type
.
social.technet.microsoft.com/Forums
