Page 1 of 1

Oracle Insert and Update

Posted: Mon Aug 30, 2010 5:44 am
by kumar66
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

Posted: Mon Aug 30, 2010 6:21 pm
by keshav0307
yes

Posted: Wed Sep 01, 2010 1:22 am
by natashab
Yes,a single job can be designed to both insert and update records