Netezza Connector > Mappings and mapping tasks with Netezza Connector > Netezza targets in mappings
  

Netezza targets in mappings

To write data to Netezza, configure a Netezza object as the target in a mapping.
Specify the name and description of the Netezza target. Configure the target and advanced properties for the target object.
The following table describes the target properties that you can configure in a Target transformation:
Property
Description
Connection
Name of the target connection.
Target Type
Type of the target object. Select Single Object, Multiple Objects, or Parameter.
Object
Name of the target object.
Operation
Target operation. Select Insert, Update, Upsert, Delete, or Data Driven.
The following table describes the Netezza advanced target properties:
Property
Description
Pipe Directory Path
Path for the Secure Agent to create the pipe for the external table.
If you do not specify the path, the Secure Agent uses the following directory to create the pipe for the external table:
<Secure Agent installation directory>/apps/Data_Integration_Server/data/temp
Error Log Directory Name
Not applicable.
Enable Insert
The Secure Agent inserts rows into the target table and enforces key constraints.
Default is selected.
Enable Delete
The Secure Agent deletes rows from the target table.
Default is selected.
Enable Update
Required. The Secure Agent updates the rows based on the update strategy option that you specify. Select one of the following values:
  • - Update as Update. The Secure Agent updates all rows flagged for update.
  • - Update as Insert. The Secure Agent inserts all rows flagged for update.
  • - Update else Insert. The Secure Agent first updates all rows flagged for update if they exist in the target. It then inserts the remaining rows marked for insert.
  • - None. The Secure Agent does not update any row.
Default is None.
When you use the Update property, the Secure Agent does not enforce key constraints and writes duplicate rows with the same primary key into the target table.
Truncate Target Table Option
The Secure Agent truncates the target before loading.
Run the truncate table command.
Default is disabled.
You cannot use the Truncate Target Table option when you create a new target at runtime.
Delimiter
Required. Set the delimiter to any value supported by the Netezza Performance Server. The delimiter separates successive input fields. The value must not be a part of the input data.
Default is |.
NullValue
NullValue parameter of the external table. The Secure Agent uses the NullValue internally. Maximum value is one character.
Default is blank.
EscapeCharacter
Escape character of the external table.
If the data contains NULL, CR, and LF characters in the Char or Varchar field, you need to add an escape character for these fields before loading.
Enter a backslash (\) as the escape character.
Quoted Value
QUOTEDVALUE parameter of the external table.
Select SINGLE or DOUBLE to enclose the field in single or double quotes. Select NO to omit quotes.
Default is NO.
The quoted value is not a part of the data.
Ignore Key Constraints
Ignores constraints on primary key fields.
When you select this option, the Secure Agent can write duplicate rows with the same primary key to the target.
Default is disabled.
The Secure Agent ignores this value when the target operation is “update as update” or “update else insert.”
Duplicate Row Handling Mechanism
Determines how the Secure Agent handles duplicate rows. Select one of the following values:
  • - First Row. The Secure Agent passes the first row to the target and rejects the rows that follow with the same primary key.
  • - Last Row. The Secure Agent passes the last duplicate row to the target and discards the rest of the rows.
Default is First Row.
Bad File Name
Not applicable.
Socket Buffer Size
Required. The socket buffer size to set to increase session performance.
Set a size of 25 to 50% of the DTM buffer size. You might need to test different settings for optimal performance. Enter a value between 4096 and 2147483648 bytes.
Default is 8388608 bytes.
Control Character
Required. CTRLCHARS parameter of the external table to transfer data that contains control characters.
You can enter control characters for Char and Varchar fields. If you enter a control character, you must add an escape character for the NULL, CR, and LF fields.
Default is TRUE.
CRINSTRING
Required. CRINSTRING parameter to transfer data containing carriage returns (CR).
You can enter a non escape CR in Char or Varchar fields. To load the control characters present in the Char and Varchar fields, set the CTRLCHARS and CRINSTRING parameters to TRUE in the session properties for the Netezza source.
Default is TRUE.
Table Name Prefix
Prefix that the Secure Agent must add to the target table name.
For example, you can enter a target owner name to override the table name prefix in the mapping.
Target Table Name
Overrides the target table name.
For example, you can parameterize the target table name to override the table name in the mapping.
PreSQL
Pre-SQL statement that the Secure Agent runs before writing data to the target.
PostSQL
Post-SQL statement that the Secure Agent runs after writing data to the target.
Success File Directory
Not applicable.
Error File Directory
Not applicable.
Forward Rejected Rows
Determines whether the transformation passes rejected rows to the next transformation or drops rejected rows.
By default, the agent forwards rejected rows to the next transformation.