Oracle

[pandu80]

Hi,
When iam trying to load the data to oracle table it throws the error
xyz..Transformer_1: ORA-01438: value larger than specified precision allows for this column.

But i have checked the datatype and length of that field and it is Decimal and Precision 9.

When i tried to insert the '1' also it throws the same error.

any help would be appreciated.

[ray.wurlod]

Hi,
When iam trying to load the data to oracle table it throws the error
xyz..Transformer_1: ORA-01438: value larger than specified precision allows for this column.

But i have checked the datatype and length of that field and it is Decimal and Precision 9.

When i tried to insert the '1' also it throws the same error.

any help would be appreciated.

Import the table definition from Oracle, perhaps into a different category. How is the column defined there? You need to match that in your job. It is possible that "someone" has changed it in the database since you last imported it.

[Sainath.Srinivasan]

Import the col defn and create a new output link just before the last link and load the metadata there. This will help you compare them both.