what is fantrap ?
- 5 Answers
- 9587 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
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 |
1. what is the purpose of creation of universe than other data sources ? 2. which is the best method in performance tuning techniques ?
What is meaning of fullpath client in business objects?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
how to hide the prompts?
HI EVERYONE I HAVE A QUESTION I FACED A QUESTITON FROM INTERVIEWER IN WEBI REPORT CREATING CROSS TAB REPORT FOR EX: YEAR IS COLUMN WISE AND MONTH IS ROW WISE AND INTERSECTIO IS REVENUES . HE WANTS BREAKS AT FIRST 3 MONTHS IN ROW LEVEL .. COULD U PLEASE TELL ME IF ANYONE KNOWS..
Pls Explain about the different between 6.5 & Xi R2
how to prepare the documentation in business objects and where to get the requirement?
what is master-detail report
How many ways you can restrict data in business objects?
Explain how many universes can be created in a project?
how do we apply sql query on selected variables?
As im new to BO, tel me 1.How to do migration from BO6.5 to BOXIR2? 2.whats the difference b/w BO6.5 to BOXIR2. 3. whats the way both BO 6.5 n BOXIR2 file storge varies.
Teradata 
