arunabala

 Profile Answers by arunabala 

• Feb 20th, 2008

 

Hi can u please specify the question what do you use or when do u use?

Thanks
Aruna

arunabala

 Profile Answers by arunabala 

• Feb 20th, 2008

 

Hi

When we are getting any join path problem that means any closed path , then we will use aliases or contexts. 

In Universe if we have more fact tables then we will go for Contexts otherwise we will go for Aliases

Raji G

 Profile Answers by Raji G 

• Feb 24th, 2010

 

While making with between the tables, loops will be created .
When the loop will occur with the Master table (Look up table) we have to use Aliases to resolve the loops.
When the loop will occur with the transactional table we have to use contexts to resolve the loops.

Hope this answer may help you .
Thanks
Raji

raghu

• Aug 26th, 2011

 

When we got loop in the universe, we can resolve loop for using alias and context. But there is no rule for going alias and context. But if we have too many to one converges on single table we go for alias.