ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Business Objects
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
2.What is loop? How  resolve the loop?explain it?

 Question Submitted By :: Mathi
I also faced this Question!!     Rank Answer Posted By  
 
  Re: 2.What is loop? How resolve the loop?explain it?
Answer
# 1
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 ?    10 Yes 0 No
G.v.subramanyam
 
  Re: 2.What is loop? How resolve the loop?explain it?
Answer
# 2
Loop can be resolved either alias/ context.
 
Is This Answer Correct ?    6 Yes 0 No
Srinu
 
 
 
  Re: 2.What is loop? How resolve the loop?explain it?
Answer
# 3
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 ?    5 Yes 0 No
Vidya
 
  Re: 2.What is loop? How resolve the loop?explain it?
Answer
# 4
If your universe is simple in terms of tables then go for 
alias.
If your universe is complex in terms of tables then go for 
Context.
Alias entails the propogation of the universe.
Contexts are not liked by the enduser because we are 
forcing the enduser to the database which is the against to 
the universe basic rule ie to keep the endusers away from 
the database.
 
Is This Answer Correct ?    0 Yes 2 No
Swades
 
  Re: 2.What is loop? How resolve the loop?explain it?
Answer
# 5
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 ?    0 Yes 0 No
Vams_gk
 
  Re: 2.What is loop? How resolve the loop?explain it?
Answer
# 6
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 ?    0 Yes 0 No
Chakri
 

 
 
 
Other Business Objects Interview Questions
 
  Question Asked @ Answers
 
if there are 2 hierarchies 1 is a-b-c and another one is a- c which hierarchy b.o takes while we use drill mode HP1
GENARALLY WHAT ARE THE PROBLEMS ARE FACING WHILE CREATING REPORTS?  1
What is pragma?  1
what is local filter Cap-Gemini2
How to Shedule the reports in Xi R2 iFlex3
How you get the requirement from client? TCS3
When N reports are scheduled for N users, How does the BCA process /know to which user the report needs to be sent? Wipro3
Is it possible to develop reports without Universe access? IBM5
WHAT ARE THE INDEXES THAT SUPPORT DATA WAREHOUSING ? Thanks In advance Prakash BirlaSoft2
working with Business Objects 6.1(a), i m facing a problem. when i save the BO report containing chart aswell as table in .xls then the null vlues in the table automatically are converted to 0, thereby istorting the chart also. please provide me the solution as soon as possile.  1
is there any way to know how long the report executes and how many records will be returned before hitting the "run" option?  3
wat is difference b/w break and section?  3
what is the source for metrics?  2
How to Implement the the Built-in Strategy Script in BO Designer? Infosys2
is there any limit for rows and columns in cross tab  3
What is the Computation error? how to solv it?  1
When is the Repository created?  1
What is the difference between derived table and views? which one gives better performance? TCS1
What is metrics?  1
tell me about aggregate awareness in detail?  2
 
For more Business Objects Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com