Series: Subject: Topic:
Question: 15 of 394

What is the chasm and fan traps in Business Objects

Asked by: Interview Candidate | Asked on: Sep 29th, 2011
Showing Answers 1 - 2 of 2 Answers

Answered On : Sep 30th, 2011

Chasm trap The Chasm trap occurs when two many to one joins converge on a single table. For example a customer can place many orders/and or place many loans. Fan trap The Fan trap occurs when a one to many join links a table which is in turn linked by another one to many join. For example when you run a query that asks for the total orders by each order line, for a particular customer, an incorrect result is returned as you are performing an aggregate function on the table at the one end of the join, while still joining to the many end

Login to rate this answer.

Answered On : Aug 30th, 2012

View all answers by lionskashif

It is common Universe problem when you start to built schema to the scratch. Loops & Traps.

Loop: it is the close join path circle where you cant out with resolving the loop. In this case you would have less data to retrieve b/c of extra condition make your loop. mean(Actual n=n-1) and In the loop Number of Table = Number of Join. Two way to resolve the loop 1- Alias 2-Context.
check integrity check On Universe and find out the loop.
Fan Traps: Occurs when "one to many" join Fan out to another to "one to many" Joint fan out to another table.

Chasm Traps: Occurs when Three tables are join with "many to one" relationship and there is no context available to resolve the Traps. when you have a traps in your schema you will have more record coming (Cartesian Product).


Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions



twitter fb Linkedin GPlus RSS


Interview Question

 Ask Interview Question?


Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.