In order to improve the session performance check the below things
1.Use Sorted Input to the Joiner
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.
No comments:
Post a Comment