Problem in loading Integer Datatype data

hemaarvind1 · Post by **hemaarvind1** » Fri May 21, 2010 5:14 am

Hi All,

I have a CSV file as a source which has one column 'XYZ"with Number data type. I load this file to an oracle table using Dynamic RDBMS stage. When I run the job, all the other columns populate correctly except for this "XYZ' column. There are different errors in different cases:

1. If I use Integer datatype for both source and target, it gives the error saying "XYZ has import error at offset{0d}( I guess this error should do something with the source file) and the job gets aborted.

2. If I use Varchar datatype for Source and Integer datatype for the target, it loads the data,however,it loads 0 instead of the actual value.

Could you please help me in getting this problem resolved.

chulett · Post by **chulett** » Fri May 21, 2010 6:46 am

Post samples of your actual input data, please.

ray.wurlod · Post by **ray.wurlod** » Sat May 22, 2010 1:38 am

Check that your metadata, particularly for Format, are correct. {0d} is carriage return character, which suggests DOS-style line terminator.

chulett · Post by **chulett** » Sat May 22, 2010 6:44 am

That too.

sureshreddy2009 · Post by **sureshreddy2009** » Mon May 24, 2010 2:44 am

Hi,

You are reading csv file by using which stage.Please mention these details.

gssr · Post by **gssr** » Mon May 24, 2010 5:34 am

Is that column is your last column?? Check the record delimiter!

DSXchange

Problem in loading Integer Datatype data

Problem in loading Integer Datatype data

More information