Alias & context: When to use which one

system · May 18, 2005, 7:32am

Hai

I am learning aliase and context… please answer my query

What is the rules for creating aliase and conext ? In which situation u creae a aliase and context

stalint (BOB member since 2004-12-14)

system · May 18, 2005, 11:56am

hi,

To avoid Fan Trap,Chasm Trap problem we are using alias

dineshunix (BOB member since 2004-12-08)

system · May 18, 2005, 12:13pm

Check this url

Rajasekar (BOB member since 2004-07-16)

system · May 18, 2005, 12:25pm

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.

Andreas (BOB member since 2002-06-20)