Guest

• Jun 22nd, 2006

 

Loop: loop is a closed path (relation) that exists among 3 (or) more tables. For example, if we have '3' tables T1, T2, T3 then, a loop exists among these tables only when we create joins in the following fashion:

         Loop:          T1 ---> T2 ---> T3 ---> T1

To resolve the above problem, we have to create a shortcut (or) Alias to the Table T1.

         No Loop:      T1 ---> T2 ---> T3 ---> Alias (or) Shortcut of T1

saivenkatesh

 Profile Answers by saivenkatesh 

• Jun 22nd, 2006

 

Loop is a closed path that exists among '3' (or) more tables. for example, if we have '3' tables T1, T2, T3 then, loop will exists among these tables only when we create joins in the following fashion:

         Loop:      T1 ---> T2 ---> T3 ---> T1

To resolve the problem of loops, we have to create a shortcut (or) alias to one of the existed tables:

         No Loop:    T1 ---> T2 ---> T3 ---> Alias (or) Shortcut of T1

rkiranbedi

• Mar 2nd, 2007

 

 Loop is a closed Path. it can be exist b/w fact &dimensions, to resolve these we have to use shortcuts

ASHOK1324

 Profile Answers by ASHOK1324 

• Apr 23rd, 2009

 

Loop: Loop is a closed path (relation) that exists among 3 (or) more tables. Loop gets created when "N" tables have "N" joins.

For example if we have '3' tables T1 T2 T3 then a loop exists among these tables like this.
Loop: T1 ---> T2 ---> T3 ---> T1

To resolve the above problem we have to delete unnecessary joins (or) create a shortcut[Alias] table for the selected query subject and create the last join with shortcut query subject.
No Loop: T1 ---> T2 ---> T3 ---> Alias (or) Shortcut of T3