DSXchange

Hi Deepa, I can suggest how we can do in Server edition , but i don how it works for parallel In server Step 1: Use Field function such that, Field(Read_Eg.Job_Desc,',',1) and so on till you have your end ',' ie if you have 10 ',' seperated then you have to use 10 field functions and make all these ...

Hi, Thanks for your response.
The source and target character set are of NLS UTF-8 setting. And i want the special characters which is not processed to capture in the Reject file, then only we can correct it and re process again.

Hi, I am trying to design a job such that if an exception occurs it should write to a file or table i.e Out of 4 rows from source 2 rows have Varchar2(15) and other 2 rows have Varchar2(12), and the target has a structure of Varchar2(12). When job runs it throws the warning saying inserted value too...