Hi,
Before post message, first search in the forum. I think that would be the best way to find the solution. If you could not find the topics related to your topic then post message.
Rule of thumb:
-
Use alias tables if your dimension tables play multiple roles, for example Address table playing the roles of Ship From/Ship To.
-
Use contexts for fact tables, one context per fact table.
Aliases and contexts are used to resolve fan/chasm traps and loops.
check this link
https://bobj-board.org/t/42567/4
Adi (BOB member since 2006-03-03)