How to improve session using Joiner Transformation?

In order to improve the session performance check the below things
1.Use Sorted Input to the Joiner

Use sorted Input to the Joiner Transformation for improving the session performance. This reduces the time taken by Integration services

2.Unsorted Data

For an unsorted Joiner transformation, use the source with fewer rows as the master source and the other as detail.

3.Sorted Data

For a sorted Joiner transformation, use the source with fewer duplicate key values as the master source and the other as detail.

4.Use Database Join

In some cases we cannot join at session level, in that case we need to join at Database level. Joining at database level improves the session performance. For joining at database level

• Create stored procedure to perform the join
• Use the Source Qualifier transformation to perform the join.