First, we must choose the appropriate configuration files. Then we must choose the appropriate partition and buffer memory. Sorting data and dealing with null-time values are two issues we must address. Instead of using the transformer, we should try using alter, copy, or filter. Reduce the amount of superfluous metadata that is propagated between phases.