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

Question

Suppose we have a Source Qualifier transformation that populates two target tables. How do we ensure TGT2 is loaded after TGT1?

Answer 1

Two sources should have primary and Foreign key relation ships.

Two sources should have matching data types.

Basic need to join two sources using source qualifier:

1) Both sources should be in same database

2) The should have at least one column in common with same data types