Skip to Content
0

CHASM AND FAN TRAPS - ALIASED TABLE SCENARIOS QUESTIONS

Jan 18, 2017 at 07:21 PM

32

avatar image
Former Member

Hi All,

I understand the concept of Chasm and Fan trap, my questions are:

if there is scenario like A - < B -< C in this one table A is an aliased table - so does this still a Fan trap? If yes how do I solve it ?

Now next scenario A -< B -< C -< D >- E in this table A and D are aliased tables so does this join path creates a trap - its understood that B -< C -< D is Fan trap and how do I solve this scene?

Appreciate any help,

Regards,

DA

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers