what is fantrap ?

Answers were Sorted based on User's Feedback



what is fantrap ?..

Answer / kishore pothuri

A fan trap is a type of join path between three tables when
a “one-to-many”
join links a table which is in turn linked by another “one-
to-many” join. The
fanning out effect of “one-to-many” joins can cause
incorrect results to be
returned when a query includes objects based on both tables.

Is This Answer Correct ?    9 Yes 0 No

what is fantrap ?..

Answer / prasanna.ramesh1

when there is one-to-many jointo a table that "fans out"
into another "one- to-many" join to another table.this
problem is called fan trap.

Is This Answer Correct ?    3 Yes 0 No

what is fantrap ?..

Answer / vijay

A fan trap is a table between three tables when A one to
many join links a table which is in turn linked by another
one to many join.the fanning out effect of "one-to-many
joins can cause incorrect results to be returned when a
query includes objects based on both tables

Is This Answer Correct ?    1 Yes 0 No

what is fantrap ?..

Answer / ramesh

the fan trap is let we take 3 tables the 1 table is joined to
2 table with 1 : N Cordinality and 2 table is joined to 3 table with 1 : N cordinality

I.e 1.....(1:N)......2....(1:N).....3

then it it forming a fan trap.

it does through any errors but the the required data will not get corectly

so by using alias we can resolve this traps

Is This Answer Correct ?    1 Yes 0 No

what is fantrap ?..

Answer / kvchowdary

if a table which is going to connect some other table with
one- to- many cardinalities which is having cardinalities
with some other tables

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Business Objects Interview Questions

Tow tables is there employee, projects . (many to many) one employee has different projects and one project has different employees . how we can achive the data from both

2 Answers   Hexaware,


how do u resolve contexts ?

6 Answers   Wipro,


Can Bo generates the Report from the cubical data Explain?

0 Answers   Wipro,


i want to use prompt for select the country names. eg, india. japan. america. like that. which delimeter is used for to seperate the countries?

5 Answers   TCS,


u drag 2 sources from 2 diff dataproviders,how we take these 2 sources into 1 single report, how we give the link these 2 sources

4 Answers   IBM,






WHAT IS SYNCHRONIZATION IN BOXI?

2 Answers   HCL,


How to create a tooltip in Webi? Is there a way to create Tooltips in Webi reports for non- hyperlinked columns? Users should be able to hover over a value in a column in the report and that should show a tooltip box with more detail regarding that column value. This is possible when you hyperlinked the column,Is it possible when you dn't have hyperlinking? Thanks in advance.

1 Answers  


if we run a report it is taking so much time to display the report,what to do to increase th performance of the report

3 Answers  


Is it possible to create a new calendar using BO? Ex:- Wants to create a calendar where the year starts with the 1feb - 25Feb. Next month from 26Feb - 14Mar.

1 Answers  


What are steps to be taken care to create a good Universe?

2 Answers  


What is the server based ranking? and its usage?

2 Answers  


am a fresher hw to get real time experience?

1 Answers   Cap Gemini,


Categories