Tuesday, 28 April 2015

Informatica Issue: ORA-01438

Sometime we used to get an error while running an Informatica workflow as below.

Error:

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

Cause:

Datatype defined for the column is not as per the data from coming from source.

Solution:

Change the datatype NUMBER(x,y) to NUMBER.


Enjoy and stay well !! :)




No comments:

Post a Comment

Power BI: Show Last Data Refresh on Dashboard

 To show last data refresh on Power BI report follow the below steps. 1. Open Report Query Editor Mode. 2. Clink on Get Data -> Blank...