We will consider the one with lesser number of records as master as with this approach the data to be cached would have to be less and hence the performance can be improved.
Above answer was rated as good by the following members: hasim_geek
We will consider the one with lesser number of records as master as with this approach the data to be cached would have to be less and hence the performance can be improved.
The joiner transformation compares each row of the master source against the detail source. Hence, fewer number of rows in master means fewer iterations of join comparison.
Secondly It is easier to cache the table with fewer number of rows.
Hence, using the table having the fewer number of rows as a master improves the performance.
1 
0