Path to the gpload

The path to where the GPload utility is installed.

Control file

Defines the name of the GPload control file that will be generated.

Note: when executing the Greenplum Load step in a clustered configuration (multiple ETL servers), it is recommended that you use variables to create unique file names for each copy of the step.  For example:

control${Internal.Step.CopyNr}.cfg

Error table

Defines the target table where error records will be written to.   If the table exists it will not be truncated before the load.  If the table does not exist it will be created.

Maximum errors

Defines the maximum number of errors to allow before the load operation is aborted.  Erros are logged to the specified "Error Table".

Log file

Specify the location for where GPload will write log information.  This information is what would be displayed in a terminal or window if gpload was executed at the command line.

Data file

Defines the name of the Data file(s) that will be written for subsequent loading in the target tables by GPload.

Note: when executing the Greenplum Load step in a clustered configuration (multiple ETL servers), it is recommended that you use variables to create unique file names for each copy of the step.  For example:

load${Internal.Step.CopyNr}.dat

Delimiter

Delimits the fields written to "Data file". This delimiter is then specified in the generated control file.

Encoding

Specify the character set encoding of the data file.  Supported encodings are: 

       BIG5, EUC_CN, EUC_JP, EUC_KR, EUC_TW,
       GB18030, GBK, ISO-8859-1, ISO_8859_5, ISO_8859_6, ISO_8859_7, ISO_8859_8,
      JOHAB, KOI8, LATIN1, LATIN2, LATIN3, LATIN4, LATIN5,
      LATIN6, LATIN7, LATIN8, LATIN9, LATIN10,
      MULE_INTERNAL, SJIS, SQL_ASCII, UHC, UTF8,
      WIN866, WIN874, WIN1250, WIN1251, WIN1252,
      WIN1253, WIN1254, WIN1255, WIN1256, WIN1257, WIN1258