Interested to Buy Any Domain ? << Click Here >> for more details...
2.What is loop? How resolve the loop?explain it?
- 11 Answers
- 63831 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 |
How to create a Pop-up in BOXIR2. Ex:- A class is having an object as "AGE", whenever this object is used in the reporting level automatically a pop- up will be coming which shows a prompt as "Please use the object DOB".
Explain in Detail about Measure Objects? and what is the use of it? How to create it?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
When any new universe changes are deployed how does the end user get the view of the new classes/objects added(aprt from specs doc)?
What are the Input and Output Context Operators.
When we use aggregate awareness function in designer?
What is Indexing? how did u implement indexing?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
I have saved one file in GMT as a standard time and the server must convert it into local time. How to do it?
what are slowly changing dimensions, confirm dimensions?
How we will see which trap(Chasm trap or Fantrap) was used in the Universe ?
How to link one location universe to other location universe
Teradata 
