There are some simple things you can do while designing a transform script to improve its overall performance.
- The Filter rows transform should be placed as early in the transform script as possible.
- In a Join transform, the primary data set should be the largest data set.