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.

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.

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

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

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

any of the person working on encyclopedia? give the explanation briefly?

1 Answers   TCS,

---

3.what is alias?

5 Answers   Business Intelligence Analytics, TCS,

---

can i use stored procedure in webi?

4 Answers   CTS, Wipro,

---

HOW TO HIDE Column in WEBI & DESKI?

6 Answers  

---

What is aggregate table and aggregate fact table ... Any examples of both?

0 Answers  

---

what is aggregate navigation?

3 Answers   Countrywide, CTS, HCL,

---

1)Difference between BO 5.1.2 and BO 6.5.1 and also BO XI (R2)?? 2)Difference between oracle 8i amd oracle 9i? 3)Difference between SQL and PL/SQL? 4)what is Broad cast Agent? 5)what is prompts? 6)master detail format means? 7)performance tuning of reports means? 8)ad-hoc reports means? 9)can't we generate reports without creating universe?

3 Answers   Oracle,

---

Hi friends How to design Xcelsius dashboard trough "SAP Netweaver connection" please explain steps for SAP Net weaver connection.

1 Answers  

---

Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

1 Answers  

---

if there are 2 hierarchies 1 is a-b-c and another one is a- c which hierarchy b.o takes while we use drill mode

3 Answers   HP,

---

How many universes will run maximum in single project

1 Answers   HP,

---

how to sort on a particular object,that object is not picked up while creating the cross tab but we need to sort on the object that is not in the cross tab????

2 Answers   Infosys, Keane India Ltd,

---