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!

partitioning and Informatica

391014Dec 13 2006 — edited Dec 14 2006

I know Informatica 7.1.3 has bulk processing capability. When you create partitions in a session, do you also need to create partition on the actual Oracle source table or does the session take care of it? Also what about parallel processing in Informatica? How does it work? Does it have to be on the source table or target table?

Is there any limit to the number of partitions? If we have more partitions, does it improve the performance?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 11 2007

Added on Dec 13 2006

2 comments

739 views