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.
Problem in loading Integer Datatype data
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 50
- Joined: Mon Jan 21, 2008 9:35 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 62
- Joined: Sat Mar 07, 2009 4:59 am
- Location: Chicago
- Contact:
More information
Hi,
You are reading csv file by using which stage.Please mention these details.
You are reading csv file by using which stage.Please mention these details.
Suresh Reddy
ETL Developer
Research Operations
"its important to know in which direction we are moving rather than where we are"
ETL Developer
Research Operations
"its important to know in which direction we are moving rather than where we are"