Problem in loading Integer Datatype data
Posted: 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.
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.