DSXchange

Hi Ray, I am doing the same in my jobs. Before inserting records into Oracle I am performing a lookup with the Reference table. So I can handle the referential integrity problem. But I am searching for a simpler solution. If we can reject all the referential integrity constrain violated records from...

Hi All,

Any workaround or solution for this strange problem?

Thanks And Regards,
dinthat

Hi ArndW, I am using rejectlink and the output reject record option in Oracle stage is set true also. When a primary key violation is occuring, I am getting such records in reject link. But whenever a referential integrity constrain violation is occuring, I am not getting those records in reject lin...

Hi All,

Any idea about such an option in oracle stage? I am using upsert method to load data.

Thanks in advance,

dithat

Hi, In my job I am inserting a set of records into Oracle table using Oracle Enterprise stage. But whenever a referential integrity constarint violation is ocuuring, the job gets aborting and showing FATAL ORA error in the Director. These records are not going into rejection link. Is there any solut...

I am also facing the same issue while performing update then insert in parallel jobs.

Is there any work around or solution for this issue? Pls help.