What r the basic needs to join two sources in a source qualifier?

Two sources should have primary and Foreign key relation ships.
Two sources should have matching data types.

Interview Candidate
Sep 21st, 2004
3
2315

Showing Answers 1 - 3 of 3 Answers

rishi

Dec 14th, 2005

The both the table should have a common feild with same datatype.
Its not neccessary both should follow primary and foreign relationship. If any relation ship exists that will help u in performance point of view.

Surendra

Apr 9th, 2006

Also of you are using a lookup in your mapping and the lookup table is small then try to join that looup in Source Qualifier to improve perf.
Regards
SK