2.What is loop? How resolve the loop?explain it?
- 11 Answers
- 60382 Views
- TCS, UHG, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / g.v.subramanyam
a situation occures more than one path exists from one table
to another table.
to reslove the loops we can use the allias ans context.
if a loop contains only one lookup table then the loop can
be resolved by detecting the alias.
if a loop is having 2 or more fact tables(multiple fact
tables) then the loop can be resolved by detecting context.
| Is This Answer Correct ? | 71 Yes | 8 No |
Answer / 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 |
Answer / rahul tandon
Loop is a situation in the BO universe design process. A
circular path of joins is formed between the tables. The
SQL queries are not able to interpret the joins; this
results in the wrong results from the queries; often less
records are retrieved than the actual number of records.
A loop situation can be resolved by Aliases and Contexts.
Make sure to break the joins(circular path) by aliasing the
table(dimension table) which has 1n's coming out of it from
both the end. The path then gets broken and ends as two
different path, one ending at the original dimension table
and the other at the aliased table(of that dimension). Both
of the paths now convey a differnt business case scenario
and depending upon the scenario a particlar path(query has
to be fired).
| Is This Answer Correct ? | 16 Yes | 1 No |
Answer / vams_gk
loop is nothing but a continuous data flow .it is a pipe
line.it is a close path end to end..using alias table we
can resolve loop s
| Is This Answer Correct ? | 18 Yes | 8 No |
Answer / stalin
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
1.Aliasing
2.Context
3.Short cut join
if our table having only one lookup then we go for the alias
concept to resolve the loop.
if our table having more than one lookup the we go for the
context to resolve the loop
Short cut join will also resolve the loops
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / chakri
A loop is a set of joins that defines a closed path through
a set of tables in a
schema. Loops occur when joins form multiple paths between
lookup tables.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / srikanth
loop can produce instances of a query where too few rows of data..
by using able aliases and contexts to resolve the loop.
alliases means it breks the loop and it is same as the original table only differ in name..a table occurs twice in the query with the diff purpose.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / chaitu
Loop is a closed circuit path.it fetches the less number of records than we expected.
by resolve these loops we are having three methods
1)context
2)Alias
3)short cut join
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / veeru
@loop:
we can say simply like:
loop is a contineous path between
the tables.
we can say another way: if there are number of tables
extractiing with number of ralations ships connecting with
each other is called loop.
two ways to we can resolve the loop
1) Alias
2)context
if our table having only one lookup then we go for the alias
concept to resolve the loop.
if our table having more than one lookup the we go for the
context to resolve the loop
| Is This Answer Correct ? | 2 Yes | 2 No |
What are steps to be taken care to create a good Universe?
how get the grand total in master-detail report?
Iam having an report it contain n number of rows i want to desplay each rows in one colur pls explain me its very important
What is the most complex report you have developed. Explain and how did you overcome??? Please give some examples
WHAT IS CARDINALITY?
what types of challenges we are faced in creating web i reports .can you please explain with some examples.
What is diff b/w Alias and Contexts in which situation we are using contexts instead of Alias?
I have only 1 dataprovider and using that i have to create 2 tabular report on Webi on same page. One report will display all the salary details and other report will display only max salary. How will you achieve this.
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
What is the merge dimension?
What is self join
What services the broadcast agent offers on the server side?
Teradata 
