How to load Informatica Rejected rows due to 'Database errors' to a relational table

Question

While running a mapping I am getting couple of database errors and jobs failed 1.) Arithmetic Overflow error 2.) Conversion failed when converting date and/or time from character string.

This is purely data issue(datatype error and data length issue) and I want to reject these records and write it in a separate error table.

The .bad files in which these records are written consists of characters which looks like junk (',N,N,N,N' AND ',D' AND ',0'), I am not sure on what basis we get these characters.

• Do we get this for null values? and how to overcome this and get the exact output?

• Is it possible to write these rejected records directly to a relation table(error table with same structure as the target table) or a way around to achieve this?

Answer 1

Hey Vankat just lookig at you problem try to filter out the records which doesn't meet your criteria by putting condition like (data type,length)at router transformation and route them to error table or capture that recods in a flat file. Hope this will give you a clear picture.

Answer 2

You could use a router transformation to route every field which does not meet your criteria to the error table. This way you will handle them before they become bad rows.