Over the years of working with DataStage I have come across some tips that I find can be huge time savers when working with the DataStage Transformer stage. Here are two that I find really useful in real world projects – Propagate Values and Derivation Substitution.