2.What is loop? How resolve the loop?explain it?
- 11 Answers
- 61907 Views
- TCS, UHG, I also Faced
- E-Mail Answers
Answer Posted / vidya
Loop is a Multiple paths between the tables selected in
queries. Or you can say loop is a closed path structure.
Loops can be resolved by…
ALIASES
•Alias - Same as the namesake in SQL.
•Exact duplicate of the original table.
.A different name “tricks” the SQL query to accept that you
are using 2 different tables.
CONTEXTS
•Rule which helps BO decide which of the 2 paths to choose
in a loop.
•BO prompts the user to indicate the correct perspective
(relevant path) for the query.
When to Alias
A loop with a single lookup table should be resolved by an
alias
A lookup table can be identified by its cardinality
A lookup table only has the ‘one’ end of joins attached to
it
| Is This Answer Correct ? | 66 Yes | 4 No |
Post New Answer View All Answers
Explain in detail about type 2(scd),
how get the grand total in master-detail report?
What is the difference between business requirement document and use case document.
Can anybody tell me what are the tuning problems?
Can we create universe with no cache??
Explain in detail about type 1?
Is there any other repository domains rather than universe, security, document?
When to use local filter and when to use global filter?
Explain the data types present in bo and what happens if we implement view in the designer and report?
Explain about a tricky situation for which you found a very simple solution?
In banking domain how many Fact tables,Dimension table are present?
Explain what is the difference between business requirement document and use case document.
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
What is aggregate table and aggregate fact table ... Any examples of both?
