DSXchange

The datatype in oracle is supposed to be a number. However, I tried with using datatype as varchar also. For either number or varchar, it is giving the same error.

Hi Manoj,

the problem is I cannot change the files as these are sent by the client. hence I could not change the delimiter.

please suggest if I can let the client know that I cannot load the data if it is in the current format due to comma present in the data.

Hi Sainath,

Yes I have specified that the fields are quoted.

I am using the sequential file at the source level.

I could not remove the commas in between the data as it is part of the data. I have to load the data as it is .

Yes, comma is the delimiter used . It returned an oracle error :

ORA-01722: invalid number

I am not sure if it is due to comma. please confirm.

Hi, I am having data as follows in the sequential file which is the source. "39368,39399,39429","TEY/MTH10/2007","2007 October - 2007 December" The source file is a comma separated file (CSV file). I have to load this data to an oracle table. I could not load this to th...

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....

We have a sequence job which has two jobs running one after other. The task of two jobs is mentioned below: First Job ---> Clears a hashfile. Second Job---> The cleared hashfile is being used as a lookup. The name of the hashfile referenced in first and second jobs is same.Please note that even thou...

you can create a new field in the job called 'modified date' which holds the date when the record is updated. If there are new records, compare the date with modified date. Add a filter such that only last loaded records are loaded. this can be achieved by comparing the record load date with the ,mo...