Answer Detail: RE: Join path Problem

GeekInterview.com > Interview Questions > Data Warehousing > BO Designer

Print |

Question: Join path Problem

Answer: What is joinpath problem?

January 01, 2008 04:19:34	#1
amchoo_vr	Member Since: January 2008 Total Comments: 1
RE: Join path Problem
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.