Things to avoid while designing data transformations

When a transformer is connected to the data writer it takes the list of fields from the 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