Interested to Buy Any Domain ? << Click Here >> for more details...
what is fantrap ?
- 5 Answers
- 10842 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 |
what is canned universe and canned reports in bo?
1.what is the difference between development,maintainace and support in bo? 2.what is dynamic date prompt?Is it feasible to create dynamic date prompt in universe?what is the procedure? 3.how can u say that a report is complex ,simple or medium? 4.yesterday i had run the report it took max 30 sec to run the report.but today i came and refresh the same report ,more than two hours completed,still result not came?where is the issue might be?note that at universe and report level no issues?where u will go fro 3rd verification?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
what is incompactabulity error in sap bo
what is difference between Rich client web intelligence and Boxir2 web intelligence
Can we link the oracle and excel universess?
Without using OBJECTS Can i write AND run a query in webi/desi? HOW?
what r the disadvanges in boxir2
what is static filter and dynamic filter
What is the diff b/w BO webi reports, crystal reports and xcelsius ? Thanks...
What are the types of errors you faced while creating a report from two different data providers
Explain which versions are used in the bo dashboard work?
Teradata 
