Things to avoid while designing data transformations

  1. 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
  2. There is no need to sort data before using Joiner
  3. The last object before data writer must be always data transformer
  4. 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

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL forum

  • knowledgebase/things_to_avoid_while_designing_data_transformations.txt
  • Last modified: 14/07/2021 06:53
  • by admin