Netezza Connector

Back Next

Netezza sources in mappings

In a mapping, you can configure a Source transformation to represent a Netezza source.

The following table describes the Netezza source properties that you can configure in a Source transformation:

Property	Description
Connection	Name of the source connection.
Source type	Type of the source object. Select Single Object, Multiple Objects, or Parameter.
Object	Name of the source object.

The following table describes the Netezza filter options that you can configure in a Source transformation:

Property	Description
Filter	Filter value in a read operation. Click Configure to add conditions to filter records and reduce the number of rows that the Secure Agent reads from the source. You can specify the following filter conditions: Not parameterized. Use a basic filter to specify the object, field, operator, and value to select specific records. Completely parameterized. Use a parameter to represent the field mapping. Advanced. Use an advanced filter to define a more complex filter condition on a dimension or metric.

Property

Description

Filter

Filter value in a read operation. Click Configure to add conditions to filter records and reduce the number of rows that the Secure Agent reads from the source.

You can specify the following filter conditions:

Not parameterized. Use a basic filter to specify the object, field, operator, and value to select specific records.

Completely parameterized. Use a parameter to represent the field mapping.

Advanced. Use an advanced filter to define a more complex filter condition on a dimension or metric.

The following table describes the Netezza advanced source properties that you can configure in a Source transformation:

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
Delimiter	Required. Delimiter separates successive input fields. You can enter any value supported by the Netezza Performance Server. The value can be a part of the data for the Netezza source. Default is \|.
NullValue	NullValue parameter of an external table. The Secure Agent uses the NullValue internally. Maximum value is one character. Default is blank.
EscapeCharacter	Escape character of an external table. If the data contains NULL, CR, and LF characters in the Char or Varchar field, add an escape character in the source data before you extract. Enter an escape character before the data. The supported escape character is backslash (\).
Socket Buffer Size	Required. The socket buffer size that you must set to increase the mapping performance. Set from 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.
SQL Query Override	Overrides the default query. Enter the SQL query that the Secure Agent must use to query data from the Netezza source.
Owner Name	The Netezza schema name.
Source Table Name	Overrides the source table name. For example, you can parameterize the source table name to override the table name in the mapping.
PreSQL	Pre-SQL statement that the Secure Agent runs before reading data from the source.
PostSQL	Post-SQL command that the Secure Agent runs after reading data from the source.
Tracing Level	Amount of detail that appears in the log for the transformation. Use the following tracing levels: Terse Normal Verbose Initialization Verbose Default is normal.

Rename Saved Search

Table of Contents

Netezza Connector

Netezza Connector

Netezza sources in mappings

Netezza sources in mappings