PowerExchange for Vertica User Guide for PowerCenter

10.4.0
- 10.5.4
- 10.5

Back Next

Session Configuration for Vertica Targets in Bulk Mode

To write data in bulk mode, configure the session to use a Vertica bulk connection and Vertica bulk writer. The copy command uses the session properties to write data to the Vertica target.

You can configure the session properties for Vertica targets in the

Transformations

view on the

Mapping

tab. Define the properties for each target instance in the session.

Method: The method that the copy command uses to write data to the Vertica target.
The method is set to INSERT because you can only insert data to a Vertica target. You cannot update or delete data.
Copy Method: The copy method that the copy command uses to write data to the Vertica target.
You can specify the copy method as auto, direct, or trickle.
Default is auto.
Delimiter: The character that separates successive input fields.
Default is |.
Escape As: The character that treats special characters in the data as regular characters.
Default is \.
Null AS: The character that the PowerCenter Integration Service replaces null values with when it writes data to the pipe. When the copy command reads the data from the pipe and writes it to the Vertica target, it converts the Null AS value to NULL.
Default is \n.
Quote: The character within which each column value gets enclosed. This option helps improve the readability of the data.
Default is “.
Exception File Path: The file path where the PowerCenter Integration Service creates the exception file.
Default is
$PMRootDir/Temp/
.
Rejected File Path: The file path where the PowerCenter Integration Service creates the rejected file.
Default is
$PMRootDir/Temp/
.
Abort On Errors: Select this option to configure the PowerCenter Integration Service to fail the session when it encounters an error.
Truncate target option: Select this option to truncate the Vertica target table before the PowerCenter Integration Service writes the data to the target.
Windows pipe buffer size: The size that the PowerCenter Integration Service allocates to buffer data before it writes the data to the Vertica target.
Enter a value between 1 KB and 2096128 KB.
Default is 4 KB.
You might need to test different settings for optimal performance. This attribute is applicable if the Informatica servers run on Windows operating systems.
Pipe Location: The file path where the PowerCenter Integration Service creates the pipes that it uses for data transfer.
Default is
$PMRootDir/Temp/
.
This attribute is applicable if the Informatica servers run on UNIX operating systems.
Reject Max Records: Enter the maximum number of records that the PowerCenter Integration Service can reject after which it must fail the session.
Connect Non-Data Nodes: Select this option to connect to a non-data node to improve performance. Non-data nodes are high-performance nodes that are used for data loading.
Enable File Staging: Select this option to create a staging file in a local directory.
Default is disabled.
Stage File Directory: The file path where the PowerCenter Integration Service creates the staging file.
Data Compression mode: On a UNIX operating system, use this option to compress the data before you write it to the staging file. The PowerCenter Integration Service uses this attribute only if you enable file staging. Otherwise, it ignores this attribute.
You can specify the data compression mode as GZIP.
GZIP Compression factor: If you select the GZIP data compression mode, set a compression factor in the range of 1 to 9.
Default is 6.
Miscellaneous Attribute: Use this field to configure any Vertica attribute that is currently not available in the session properties.
Enter any attribute that Vertica supports along with the attribute value.
Use the following format:
ATTRIBUTE_NAME_1,ATTRIBUTE_VALUE_1; ATTRIBUTE_NAME_2,ATTRIBUTE_VALUE_2; <and so on>
Table Name Prefix: Enter a target owner name or prefix to override the table name prefix in the mapping.
Target Table Name: Enter a target table name to override the table name in the mapping.

Rename Saved Search

Table of Contents

PowerExchange for Vertica User Guide for PowerCenter

PowerExchange for Vertica User Guide for PowerCenter

Session Configuration for Vertica Targets in Bulk Mode

Session Configuration for Vertica Targets in Bulk Mode