what is fantrap ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to prepare the documentation in business objects and where to get the requirement?

1782


In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha

1829


What is the profile and package?

1765


What is the difference between business requirement document and use case document.

582


How we drill up week to month?

617






What three things do you consider to be the most important factors for a manager?

592


Explain is data mart?

590


How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4319


How to schedule the report in b.o?

562


Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,

1581


What are the join problems comes appart from loop,chasm & fan Traps

1550


i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

1610


Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3280


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

599


hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

1574