Saturday 1 September 2012

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.

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...

ShareThis