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
Yes mainframe datasets can have special characters in them. Firstly, check to see if the dataset is a delimited or fixed width file. I guess the data type should be ZONED (decimal) and define the length based upon the length defined in the copybook or talk to BA or look into requirements for it. Are you using Power Exchange to connect to mainframes? If so, after the datamap is created on PowerExchange, you can do a road test to check if the data retrieved is as per the source.
Chek specified collumn precission and increase precission size more than you entered
Increase precission size to 30 and propagrate it.Try to run again it will work.
Thank you all.
The Data set is fixed with file and using the SUbstr(dataset,45,4) for AA_ATC column.
As per substring function it should be 4 length value only.
But, it’s converting to 6 digits field while inserting into data base.