Database Reference
In-Depth Information
• Informatica push-down optimization
• Metadata driven Greenplum scripting
The connector can be integrated into Workflow Manager of PowerCenter as a target
writer.
Greenplum target configuration
Use the following target configuration for all PWX for Greenplum targets. This will
ensure that certain characters are escaped correctly, and prevent data loss and/or
code page conversion errors.
Format - CSV
Delimiter - |
Escape - \
Skip Escaping - Unchecked
Null As -\N
Quote - "
Encoding - WIN1252
Sourcing large volumes of data from Greenplum
One way to communicate with Greenplum is to configure ODBC connection for
Greenplum in Informatica, and this can prove to be inefficient in case of large
volumes; another way is to use the File-based Writable External Table feature in
Greenplum. Details on using external tables are discussed earlier in this chapter.
Also, refer the Greenplum Admin Guide for more information on this feature.
The following steps are required to integrate Greenplum File-based Writable Extern-
al Tables and Informatica:
1. Using a shell script (perhaps executed from a command task), perform the
following steps:
1. Create an empty directory on the Informatica server, for example,
mkdir /path/to/new/dir
.
Search WWH ::
Custom Search