Using Aliases and Contexts together to resolve a loop

How and in what scenario we can use Alias and context together to resolve the loop?

Questions by sreya_1234   answers by sreya_1234

Showing Answers 1 - 5 of 5 Answers

pratap_dwh

  • Feb 28th, 2008
 

If it is a loop we have to use alias,the loop is not resolved by alias then we can go for context.we dont use context because the end user is not familiar with the technical terms like context he is in a dilama to choose which context he had to select.

  Was this answer useful?  Yes

hari7878

  • Mar 27th, 2008
 

Yes,but most cases contexts are the better solutions for resolve the loops why because these are past accessing and performance.

  Was this answer useful?  Yes

metrook

  • May 27th, 2008
 

Use contexts to group the related schemas and use aliases only when one table can have multiple meanings such as a Sold To Customer versus a Ship To Customer or a Manager who is also an Employee.

  Was this answer useful?  Yes

prasadkanchya

  • Jun 3rd, 2008
 

If you have only one look up table in loop then  use Alias .

If you have look up table that is on  only one end of Join then use Alias to solve the join path problem.

If you have more than one fact table use context to solve the problem.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions