Oracle Insert and Update

kumar66 · Post by **kumar66** » Mon Aug 30, 2010 5:44 am

Hi All,

I am doing an insert and update based on the change code .
Can I do the insert and update on the same job?

I tried with around 102000 rows using ODBC connecor stage as target . One link for update and one link for insert.

The job runs fine without any issues. Want to confirm with you Gurus.

Please Advise.

Thanks & Regards,
Kumar66

keshav0307 · Post by **keshav0307** » Mon Aug 30, 2010 6:21 pm

natashab · Post by **natashab** » Wed Sep 01, 2010 1:22 am

Yes,a single job can be designed to both insert and update records