Interested to Buy Any Domain ? << Click Here >> for more details...
what is fantrap ?
- 5 Answers
- 10849 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 |
how to do Ad-hoc reporting ?
can we cretae views in universe level?
what is a filter?
5.what is LOV? where it is store?
what is maximum scope of analysis --> can we define more than 3 levels?
Explain which versions are used in the bo dashboard work?
what r the types of joins universe supports
when I am trying to schedule the report its running faster then I tried to run it manually?? why is it so that there is difference of time between scheduling and manual run for report
what is drill down?
What is #DATASYNC error how to remove it?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
wat is the difference between full clinet report and thin client report?wat is the difference between desktop intelligence and web intelligence?
Teradata 
