Join path Problem

What is joinpath problem?

Questions by kusam_m

Showing Answers 1 - 12 of 12 Answers

amchoo_vr

  • Jan 2nd, 2008
 

A join path is a  series of joins  that a query can  use to access data in the  tables linked by the joins.
Join path problem arises due to limited  way that lookup and  fact tables are related  in a  relational database.Three major join path problems are:
1. Loop
2. Chasm Trap
3. Fan Trap

This can be resolved by using aliases.

venkatesh

  • Dec 26th, 2014
 

JOIN PATH PROBLEMS

1)LOOPS
2)TRAPS

Loops can be resolved using 1)alias(can completely solve loops)
2)contexts(can only cover loop,not completely solve the loop)
Traps can be solved by using

1)chasm trap
2)fan trap

  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.

 

Related Answered Questions

 

Related Open Questions