This Snap has one document input view by default.

A second view can be added for metadata for the table as a document so that the target absent table can be created in the database with a similar schema as the source table. This schema is usually from the second output of a database Select Snap. If the schema is from a different database, there is no guarantee that all the data types would be properly handled.

• Mapper
• JSON Generator

This Snap has at most one document output view.

• Mapper

Label

Required. Specify a unique name for the Snap. Modify this to be more appropriate, especially if more than one of the same Snaps is in the pipeline.

Default value: Oracle - Bulk Load

Specify the database schema name. The suggestions in the Schema field are populated only when at least a single table exists in the schema. If no tables exist to use that schema, only SYS, SYSTEM, and XDB are populated.

The values can be passed using the Pipeline parameters but not the upstream parameter.

Default value: None

Example: SYS

Required. Specify the table that the rows will be inserted into. This list is populated based on the tables associated with the selected schema.

The values can be passed using the Pipeline parameters but not the upstream parameter.

Default value: None

Example: people

Select this checkbox to automatically create the target table if it does not exist.

• If a second input view is configured for the Snap and it contains a document with schema (metadata) from the source table, the Snap creates the new (target) table using the same schema (metadata). However, if the schema comes from a different database, the Snap might fail with the Unable to create table: "<table_name>" error due to data type incompatibility.
• In the absence of a second input view, the Snap creates a table based on the data types of the columns generated from the first row of the input document (first input view).

Default value: Not selected

Specify the absolute path of the sqlldr program in the JCC's file system. If empty, the Snap will look for it in the JCC's environment variable PATH.

Default value: None

Example: /u01/app/oracle/product/11.2.0/xe/bin/sqlldr (For Linux)

Example: C:\app\Administrator\product\11.2.0\client_1\bin\sqlldr.exe (For Windows)

Available insert modes when loading data into table.

• INSERT - Load rows only if the target table is empty.
• APPEND - If data already exists in the table, the new rows are appended to the table. If data does not already exist, the new rows are simply loaded.
• REPLACE - First delete all the rows in the existing table and then load rows.
• TRUNCATE - First truncate the table and then load rows.

Default value: APPEND

See this doc for more information.

Required. Specify the maximum number of rows which can fail before the bulk load operation is stopped.

Default value: 50

Example: 10 (if you want the Pipeline execution to continue as far as the number of failed records are less than 10)

Select this check box to use direct path load mode of SQLLDR program. Typically, used when loading large data sets. This substantially improves the bulk load performance by reducing loading time.

Default value: Selected

Select this checkbox to skip virtual columns to prevent errors while loading data.

Default value: Selected

Snap execution

Default value: Execute only

Example: Validate & execute