BO Designer - Join path Problem

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

Go To First | Previous Question | Next Question

BO Designer | Question 110 of 117

Join path Problem

What is joinpath problem?

Total Answers and Comments: 3

Last Update: August 27, 2008 Asked by: kusam_m

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

January 02, 2008 04:19:34

amchoo_vr

Member Since: January 2008 Contribution: 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.

Is this answer useful? Yes | No

April 08, 2008 06:23:28

vams_gk

Member Since: July 2007 Contribution: 4

RE: Join path Problem

we have a multiple options to solve join problem
creation alias tables for loop resolve
detect contexts
traps:
chasam trap(m:1:m)
fantraps(1:m||)

Is this answer useful? Yes | No

August 27, 2008 00:59:46

muralikrishna1982

Member Since: August 2008 Contribution: 14

RE: Join path Problem

the join path problems areee loops chasmtraps fantraps..
these can be solved by using

1) visualising analysis of schema
2) by using aliases
3) by using contexts

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank