[Informatica] ERROR('transformation error') ? Here's what you need to do

The default value of all the output ports in Informatica is set to ERROR ('transformation error'). Whenever an error occurs in the transformation, the Integration service skips the row and logs the ERROR in session log.

Therefore, whenever such an error occurs, you must look for one of the below in your Mapping:
1. Datatype conversation errorrs.
2. Divide by 0 errors or  other Expression valuation errors.
3. Call to ERROR function.