Goverdhan Reddy

• Aug 15th, 2006

 

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

lionskashif

 Profile Answers by lionskashif 

• Feb 17th, 2011

 

When you making a universe So, loop Generate bc of joins 

it is a common problem when you make universe.

loop is a cirucular path of joins. when loop occur so we have a 

2 way to solve them.......1-->Alias.....2--> Context

Alias: is a same table which we are using to solve the loop. It have a 

same columns just like a original but we change the table name to trick SQL.

Alias breaks  the loop.
Context : is a set of two different paths when Query run it will ask you which path

do you want to go to get the data.........Its not break the loop.

gotchaaaaaa............