Informatica Parameters for Optimal Performance - Aster Client

Teradata Aster® Client Guide
Product
Aster Client
Release Number
7.00
Published
May 2017
Language
English (United States)
Last Update
2018-04-13
dita:mapPath
hki1475000360386.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval
dita:id
B700-2005
lifecycle
previous
Product Category
Software
For optimal performance, set the following Informatica parameters to be as large as possible:
  • Commit Interval
    When 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