DSXchange

Hi,

Thanks for ur information.

Yes we have that option "output reject records " in Oracle Enterprise stage only for when write method is Upsert

Can you please tell me the other solutions for this problem


Thanks
Thiru

Hi, I have a parallel job to load the data into a table in Oracle database from the sequential file. I need to capture the records with SQL Error code in the reject file if the records are not loaded to the target table due to some SQL errors (say Duplicate Keys, Unique constraint). Here is my job d...

Hi Thanks for ur information I don't think it would give correct data for the year 2100 Please advice me, what will happen if year is 2100 Thanks Thiru converted date is coming as incorrect data which means incorrect year Say for example Input data : 011008 (01-10-2008) After conversion : 01101908 P...

Hi Aruna, Thanks for your help. I tried with format "%dd%mm%yy" StringToDate(ln_TTS_DelvyDate_in.pu_date,"%dd%mm%yy") it is working fine but the problem is the converted date is coming as incorrect data which means incorrect year Say for example Input data : 011008 (01-10-2008) A...

Hi Aruna, Thanks for your help. I tried with format "%dd%mm%yy" StringToDate(ln_TTS_DelvyDate_in.pu_date,"%dd%mm%yy") it is working fine but the problem is the converted date is coming as incorrect data which means incorrect year Say for example Input data : 011008 (01-10-2008) A...

Hi, I have a file which has five columms. A field "pdate" is char data type which has date values (format ddmmyy eg 011008). This date value is need to be converted before loading into a target table in oracle 9i. I have used the converion function StringToDate(ln_TTS_DelvyDate_in.pu_date,...

[quote="a.thirumoorthi"]Hi , Whenever a parallel job is triggered,There are 100-200 sessions are opening in the Unix OS. Because of these so many sessions jobs are not running it is getting hang up. Can any one please help on this issue , what are the possible reasons for this issues and s...

Hi , Whenever a parallel job is triggered,There are 100-200 sessions are opening in the Unix OS. Because of these so many sessions jobs are not running it is getting hang up. Can any one please help on this issue , what are the possible reasons for this issues and solutions for fixing this issue. Pl...