Context and Alias

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 :us: (BOB member since 2006-03-03)