Skip to Content
avatar image
Former Member

CHASM AND FAN TRAPS - ALIASED TABLE SCENARIOS QUESTIONS

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers