SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Merge vs Informatica Update Strategy

391014Dec 19 2006 — edited Dec 20 2006

How do you guys compare the two? Consider we have a large data set. About 5-10 million rows in the table and upto 1 million rows daily as insert/update. How does the performance vary if we only 10,000 rows daily as insert/update?

Any inputs are appreciated. We currently have Oracle 9i and are soon upgrading to 10g. Has the merge feature has any improvements in 10g.

thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 17 2007

Added on Dec 19 2006

5 comments

1,508 views