Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

2.What is loop? How resolve the loop?explain it?

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


Please Help Members By Posting Answers For Below Questions

8. How much supervision have you typically received in your previous job?

2251


Can we Save (save as) WEBI Doc as DESKI?

8154


Difference between b.o 5.1 and 6.1b?

1240


what are the tables used in health care domain project and columns used in report?

4503


what is document design in boxi,have u participate in that

2166


How to create Index to the table in the universe designer and how it improves the Query performence

2542


Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

1025


What is difference between webi and infoview?

1245


What is the profile and package?

2283


IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

10386


what is the difference b/w the refresh and buffered data?

2328


What is the difference between slice and dice and cross tab report?

1038


Explain how we drill up week to month?

1084


WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S

2261


how to create metric universe ?

2335