Which Is The Best Way To Resolve Loops? Context Or Alias?
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this answer should be reported.
Ch Kashif
In a schema we have only one look loop u can create Alias. But, when we have
multiple look up u can create contexts. most of the cases are using context can be
use to resolve the loops. why because more number of complexity loops and also
schema contains 2 or more fact tables in your universe design. If there are more than
one fact table use a context or if only one fact table use alias.