Saved Bookmarks
| 1. |
Which Is The Best Way To Resolve Loops? Context Or Alias? |
|
Answer» 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 ur universe design. If there are more than one fact table use a context or if only one fact table use alias. 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 ur universe design. If there are more than one fact table use a context or if only one fact table use alias. |
|