sampath

• Jul 24th, 2005

 

Rejection of records either at the database due to constraint key violation or the informatica server when writing data into target table.These rejected records we can find in the badfiles folder where a reject file will be created for a session.we can check why a record has been rejected.And this bad file contains first column a row indicator and second column a column indicator. 
These row indicators or of four types 
D-valid data, 
O-overflowed data, 
N-null data, 
T- Truncated data, 
And depending on these indicators we can changes to load data successfully to target.