Greenplum Database session properties configure the services provided by GPSS in the Informatica mapping for the Greenplum loader target. When you create a new loader target mapping, the session properties are configured to use defaults. Consider modifying the session properties for common tasks such as:
You can also use session properties to customize other aspects of the load session, such as temporary tables names and the character encoding to use. See Greenplum Session Property Reference.
Start the Informatica Developer Tool application.
If the Object Explorer view is not visible, display it by selecting Window > Show View > Object Explorer.
Click the name of the Greenplum Database loader target to display its configuration window.
Select Data Object Operations to display information about the target and its configuration properties. This view contains several tabs that provide the following information:
Click the Advanced tab to display or modify any of the Session properties described in Greenplum Session Property Reference.
The following table describes the available properties for configuring an Informatica session that uses a Greenplum Database loader target.
|Optional. Enables single row error isolation mode for this load operation. When enabled, input rows that have format errors will be discarded provided that the error limit count is not reached on any Greenplum Database segment instance during input processing. If the error limit is not reached, all good rows will be loaded and any error rows will either be discarded or captured as part of error log information. The default is to halt the load operation on the first error encountered. Note that single row error isolation only applies to data rows with format errors; for example, extra or missing attributes, attributes of a wrong data type, or invalid client encoding sequences. Constraint errors, such as primary key violations, will still cause the load operation to halt if encountered.
|Optional. Specifies an error limit for the load operation as a percentage of rows, instead of as a fixed number of rows as with
ErrorLimitRows. If both
ErrorLimitPercent are configured,
ErrorLimitRows takes precedence and
ErrorLimitPercent is ignored.
|Required. Specifies the method that GPSS uses to load data into Greenplum Database tables for this session. There are three available load modes:
|Optional. Specifies whether to truncate the Greenplum Database target table before loading data into it.
|Required if the
OperationType is Update or Merge. Specifies the column(s) to update for the rows that meet the
MatchColumns criteria and the optional
Condition for updates. Values for this property are case sensitive, and cannot contain a quotation mark (") or comma (,).
|Required if the
OperationType is Update or Merge. Specifies the column(s) to use as the join condition for the update. The attribute value in the specified target column(s) must be equal to that of the corresponding source data column(s) in order for the row to be updated in the target table. Values for this property are case sensitive, and cannot contain a quotation mark (") or comma (,).
|Optional. Specifies a Boolean condition that must be met in order for a row in the target table to be updated. The value of this property must be valid SQL that can appear in the
WHERE clause of a Greenplum Database SQL Statement. Use the token
into_table to refer to the target table name.
|Optional. Specifies the name of the schema where GPSS creates all temporary and external tables during the load operation. If this property is not set, GPSS creates external and temporary tables in the same schema as the target table. The name of each external table is formed from the hash value of the
gpfdist IP address, the target table name, and the target schema name. External tables are reused by default during load operations.
|Optional. The character set encoding of the source data. Specify a string constant (such as ‘SQL_ASCII’), an integer encoding number, or ‘DEFAULT’ to use the default client encoding. If not specified, the default client encoding is used.
|Optional. Specifies the maximum amount of time, in seconds, that the Connector will wait for GPSS to respond to a request. The Connector closes the connection to GPSS if the timeout value is reached. A value of “0” (the default) deactivates the timeout, and the Connector will wait indefinitely for a response from GPSS. Enter a value from 0 to 30 seconds.
|Optional. Defines SQL commands to run before and/or after the load operation. You can specify multiple commands to run. List commands in the order of desired execution, and enclose commands in quotes.
|Optional. Identifies the maximum number of error rows to write to the session log. The default value is