Informatica: Error handling Logic

Bad files contains column indicator and row indicator.
Row indicator: It generally happens when working with update strategy transformation. The writer/target rejects the rows going to the target

Columnindicator:
D -valid
o - overflow
n - null
t - truncate
When the data is with nulls or overflow it will be rejected to write the data to the target
The reject data is stored on reject files. You can check the data and reload the data in to the target using reject reload utility 


Example of data:



0,D,,N,16103,D,19,D,S,D,SPECIALTY,D,All Others,D,0000X,D,Unmapped,D
0,D,01,D,20555,D,17,D,T,D,PRVDR TYPE,D, name,D,261QU0200X,D,Urgent Care,D
0,D,AA,D,20555,D,17,D,T,D,PRVDR TYPE,D,name,D,0000X,D,Unmapped,D