Which is better? Lookup join or Ansi join?
I have three document type , A , B and C
I want to join A and C , but its it not possible to use lookup join so I want use ansi join , But If I join A and B and join with C , I can use lookup join
In large scale , which approach is better?
- A ansi join C
- A lookup join B lookup join C