Posted: Tue Oct 21, 2008 12:56 am
Thanks Nagaraj.
The problem was due to mismatch in the datatype.
We are getting a fixed with file and the file is read using schema file definition.
The numeric column are read as int32 using schema file and in DataStage the data flow as Integer values.
But in the final Oracle table, the columns are defined as NUMBER. So the error is occuring while loading.
After defining the columns as Integer in tables the error is not appearing.
The problem was due to mismatch in the datatype.
We are getting a fixed with file and the file is read using schema file definition.
The numeric column are read as int32 using schema file and in DataStage the data flow as Integer values.
But in the final Oracle table, the columns are defined as NUMBER. So the error is occuring while loading.
After defining the columns as Integer in tables the error is not appearing.