Answer Posted / 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 |
Post New Answer View All Answers
What is Indexing? how did u implement indexing?
How to restrict password to a user while sending a document in .pdf format
Can we create universe with no cache??
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Differences between business objects and web intelligence reports?
What is the dense rank?
Explain in detail about type 1?
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?
Can more than 1 metric be applied on an analytic in business objects?
What are the join problems comes appart from loop,chasm & fan Traps
Explain when we use aggregate awareness function in designer?
What Is The Difference Between Oltp And Olap?
What is the profile and package?