For optimal performance, set the following Informatica parameters to be as large as possible:
- Commit IntervalWhen the Commit Interval is set to a value larger than the total row count of the table, the setting will not affect the performance for that table.
- DTM Buffer Size
- Buffer Block Size