Usage Notes for Loaders

See Usage Notes for Table Loader and Cloudera Impala Tables.

In jobs that include the SCD Type 2 Loader and a Sybase target, or a Netezza target, SQL pass-through is not supported, even when you specify Yes for the Use SQL Passthru option.

In jobs that include the SCD Type 2 Loader and a Sybase target, the job runs only if you include the value UNDOPOLICY=NONE in the SQL Options field.

When the SCD Type 2 Loader Transformation is used to load Netezza or Neoview tables, the Autocommit option should be turned off in the DBMS library. To turn off this option, display the properties window for the library, select OptionsAdvanced Options, and then select the Input/Output tab. Set the Whether to COMMIT immediately after a transaction field to No.

You can set the MINMAXVARLIST option for either an SPD Server Loader transformation or an SPD Server table. However, the scope of the option depends on the type of object that you select.

When you set the MINMAXVARLIST option for an SPD Server Loader transformation, the option is applied to any table that is loaded with the transformation. To set the option on a loader, open the property window for the SPD Server Loader transformation. Then, click the Options tab and enter minmaxvarlist=xxx in the Advanced Data Table Options field (where xxx denotes the range of variables that you want to specify).

When you set the MINMAXVARLIST option for an SPD Server table, the option is applied to the table in any job when the transformation that uses the table supports table options. To set the option on a table, open the properties window for the SPD Server Table. Then, click the Physical Storage tab and click Table Options. You can then enter minmaxvarlist=xxx in the Additional Options field (where xxx denotes the range of variables that you want to specify).

When you use the Table Loader or SCD Type 2 loader transformations with a Vertica DBMS table target, you must set the AUTOCOMMIT option to No. However, you must set the AUTOCOMMIT option to Yes if the Load Style field on the Load Technique tab is set to Update/Insert and the Matching Rows field is set to either Modify by Column(s) or Skip Matching Rows.

If you receive the error message “ERROR: One or more values have been changed in the record to be updated”, then you must set the AUTOCOMMIT option to No.