Skip navigation
Contact Us
3908 Views 4 Replies Latest reply: Dec 5, 2012 1:52 AM by RK N RSS
RK N Newbie 19 posts since
Jun 30, 2011
Currently Being Moderated

Dec 4, 2012 7:18 AM

ORA-01438: value larger than specified precision allowed for this column



We have Source as MainFrame file and target is Oracle 11g.

And,We are encountering the "Value larger than specified precision allowed for this column" when the data inserting to oracle table.


Oracle code page: AL32UTF8



Informatica session log:

I found the error column after gone through the session log:



AA_ATC (AA_ATC:Double:): "100000.0000000000"




As per mapping, We have defined Source and Target as Number(4) only with include expression also.


But, in session log it's showing as 6 length of number.


Is there any special charaters in Source file????



Can you please help me on this

More Like This

  • Retrieving data ...

Bookmarked By (0)