Installation for PowerCenter and Data Quality

Back Next

Configuring Custom Properties for Microsoft SQL Server

You can configure custom properties for Microsoft SQL Server to improve bulk load performance.

Launch the PowerCenter client and connect to Workflow Manager.

Open a workflow and select a session that you want to configure.

Click the

Config Object

tab.

Change the value of the

Default Buffer Block

size to 5 MB. You can also use the following command:

$INFA_HOME/server/bin/./pmrep massupdate -t session_config_property -n "Default buffer block size" -v "5MB" -f $<folderName>

To get optimum throughput for a row size of 1 KB, you must set the Buffer Block size to 5 MB.

Click the

Properties

tab.

Change the

Commit Interval

to 100000 if the session contains a relational target.

Set the

DTM Buffer Size

. The optimum DTM Buffer Size is ((10 x Block Buffer size) x number of partitions).

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.