I am designing a dimBroker table about all the Borker information. However,
there is a table called BrokerContact in the OLTP systems. Obviously, one
broker can have multiple contacts. What is the best way to design the
relationship in the Dimension Model? Should I make it a snowflake schema for
it?

Thanks

Ed