what is fantrap ?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
What are Alerter, Filters, Breaks and Conditions?
How to link one location universe to other location universe
I WOULD LIKE TO GO FOR ONLINE CERTIFICATION FOR BUSINESS OBJECTS 6X. CAN SOMEONE GIVE ME IDEA ABOUT. Thanks in advance
How will you know the version of Bo using designer?
4 Answers Tavant Technologies,
How we will show the pop message while selecting multiple input values more than 10 in Crystal reports or any other reports?
REGULAR CLASSES for Hyperion Financial Management+ODI+HFR+FDQM is Starting From Sunday, 23th Oct, 7:00 AM IST.
What is the aggrigate navigation ? can anybody explain me with some practical example?
What is the dense rank?
Example Country Name is like India/UK or ALL In parameter I selected India or UK it should show only perticular country details in BO.If i select ALL in parameter.It should show both country data in different tables.
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
how do we schedule reports in WEBI? i want to schedule 3 reports consicutively....how can i achieve this
Tell me about a complicated object you have created?