Things to avoid while designing data transformations

When the transformer is connected to data writer it takes a list of fields from data writer, transformation below will work only if the list of fields from both data writers is exactly the same

There is no need to sort data before using Joiner

The last object before data writer must be always data transformer

When log object is present inside data transformation all log messages go through it. all validator and transformer objects must have "Write Message to Log File" and "Write Record to Rejected File" must be unchecked