What is fan trap? How do you find out? How do you resolve that loop? What is chasm trap? How do you find out? How do you resolve that loop? How you provide security for reports? Whenever you open a report it refresh automatically? How do set this. Can you use different database for different universes? What are the types of universes?  

Questions by vasanth96

Showing Answers 1 - 3 of 3 Answers

PANGANAMALA SRINIVAS

  • May 9th, 2012
 

Fan trap: one of the schema-tables in your physical realization via an rdbms has a 1:many relationship between two slave-tables but there is no path between the two slave tables! So we are clueless about the fk between them and the cardinality of the join is undefined leaving you powerless to query the data between the two slave tables
Chasm trap is a many-to-many join between two tables and requires a bridge table to resolve the context of the join.example:one product has one or many customer-orders and one customer has zero or many order-cancellations& returns

  Was this answer useful?  Yes

Give your answer:

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

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions