The Definitive Guide to Data Quality
can you not tMap with lookups and filtered outputs instead of your tFlowToIterate etc.?
I'm referring just to tMap. All I can see from your job is that you're reading from the DB and doing stuff in tJavaRow before writing with tMySQLRow. I think you should be able to bring all your requirements for the processing logic together in tMap, replacing tFlowToIterate, tJavaRow and the If connections. You'll need to provide more detail on exactly what you're trying to do if you want more help.