I’ve Got A Transformation That Doesn’t Run Fast Enough, But It Is

1.	I’ve Got A Transformation That Doesn’t Run Fast Enough, But It Is Hard To Tell In What Order To Optimize The Steps. What Should I Do?
Answer» Transformations stream data through their STEPS: That means that the SLOWEST step is going to determine the speed of a transformation. So you optimize the slowest steps first. How can you TELL which step is the slowest: look at the size of the input buffer in the log view. In the LATEST 3.1.0-M1 nightly build you will also find a graphical overview of this: HTTP://WWW.IBRIDGE.BE/?P=92 (the “graph” button at the bottom of the log view will show the details). A slow step will have consistently large input buffer sizes. A fast step will consistently have low input buffer sizes. Transformations stream data through their steps:

I’ve Got A Transformation That Doesn’t Run Fast Enough, But It Is Hard To Tell In What Order To Optimize The Steps. What Should I Do?

Answer»

Transformations stream data through their STEPS:

That means that the SLOWEST step is going to determine the speed of a transformation.
So you optimize the slowest steps first. How can you TELL which step is the slowest: look at the size of the input buffer in the log view.
In the LATEST 3.1.0-M1 nightly build you will also find a graphical overview of this: HTTP://WWW.IBRIDGE.BE/?P=92
(the “graph” button at the bottom of the log view will show the details).
A slow step will have consistently large input buffer sizes. A fast step will consistently have low input buffer sizes.

Transformations stream data through their steps: