Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


Aliases and Contexts Which once will give the better
performence when resolve the loops?

Answers were Sorted based on User's Feedback



Aliases and Contexts Which once will give the better performence when resolve the loops?..

Answer / vasanth

alias is used when two dim tables and one fact table are there in the loop ,alias is used for one dim table which has less outer joins.

Context are used when there are 2 fact tables and one dim table in the loop,we create context for one join between one fact and dim in the loop.

Is This Answer Correct ?    8 Yes 0 No

Aliases and Contexts Which once will give the better performence when resolve the loops?..

Answer / narender reddy

Join path: a join path is a series of joins that a query can use to access data in the tables linked by the joints. Join path problems can arise from the limited way that lookup and fact tables are related in a relational data base. The three major join problems that you encounter when designing a schematic are the following:
1. Loops
2. Chasm traps
3. Fan traps

Queries can return incorrect results due to the limitations in tha way that joins are performed in relational databases.

Loops: joins between tables form a continues path
Solved by: shortcut join(3 tables), aliases( more than 3 tables with one fact table), context( more than 3tables with more than one fact table),

Chasm traps: many to one joins from two fact tables converge on a single lookup table. This type of join convergence can lead to a join path problem called as a chasm trap.
Solved by: context, creating multiple SQL statements for each measure, creating multiple universes( webi only),

Fan traps: a one to many join links a table which is in turn linked by a one to many join. This type of serial many to one joins can lead to a join path problem called a fan trap.
Solved by: alias, using multiple SQL statements for each measure, creating the context using the alias.

Aliases: An alias is a table that is a exact duplicate of the original table, with a different name. The data in the table is exactly the same as the original table. Using aliases resolve loops and fan traps.

Context: context is a collection of joins which provide a valid query path for user to generate SQL. Using contexts we can resolve loops and chasm traps and assisting in some solutions of fan traps.

-------- when we use alias to resolve the loop we are using extra duplicate table, if we have more tables in schema it will decrease the performance so alias always decrease the performance compair to context.

Is This Answer Correct ?    4 Yes 0 No

Aliases and Contexts Which once will give the better performence when resolve the loops?..

Answer / raj

*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 ?    1 Yes 0 No

Post New Answer



More Business Objects Interview Questions

disadvantages of boxi

2 Answers   Accenture,


if i hv 2 reports in one block... first report contains ten rows and second report contains 100 rows. my question is ....if i want to enter the values into first report(i want more than ten rows in first report)..is it possible to get ..

1 Answers   TCS,


WHAT ARE THE VARIOUS PRODUCTS IN BO?

2 Answers   Polaris,


what r the types of joins universe supports

3 Answers  


Iam having an report there four cloums and n number of rows if i click ang one cell the report want to go to another report page which gives the detail of the cell which i click pls help me with example

1 Answers   IBM,






What is domain? How many are there in a basic setup? What are they?

1 Answers  


How to get red line in the graph at some point (value)? Example : In graph at 200000 value

1 Answers   Rolta,


what are the documentations u r created?

2 Answers   Wipro,


use scheduler to refresh report.....explain please.....

2 Answers  


What is recurring sheduling and batch scheduling?

2 Answers   TCS,


can you use inputbox in BOXI. e.g. checkbox,textbox etc.

1 Answers   ACN, Patni,


IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?

1 Answers   Accenture,






Categories