Executive Business Development Interview Question:

Explain difference between detect alias and detect context?

Submitted by: Administrator

We should use Detect Aliases and Detect Contexts to formally identify and resolve loops.
i.e.if a loop contains only one lookup table then the loop can be resolved by detecting the alias.

if a loop is having 2 or more fact tables(multiple fact tables) then the loop can be resolved by detecting context
Detect alias: resolving fan trap
Detect context: resolving chasm trap
Submitted by: