...
You can use this Snap to insert data in parallel across multi-threaded tasks to execute a high-performance data load compared to the Oracle - Bulk Load Snap.
...
Snap Type
The <Snap name> Oracle - Parallel Load Snap is a Read/ Write/Parse/Transform/Flow/Format-type Snap that reads/fetches/writes/parses/executes/transforms/calls/creates…
Prerequisites
Valid client ID.
A valid account with the required permissions.
None.
Support for Ultra Pipelines
...
Works in Ultra Pipelines.
...
Works in Ultra Pipelines if....
...
writes the specified data in the target table.
Prerequisites
A valid Oracle Thin Account or Oracle Thin Dynamic Account.
Support for Ultra Pipelines
Works in Ultra Pipelines.
Limitations
None.
Known Issues
NoneAlthough the Schema name and Table name settings both accept schema from upstream snaps and offer suggestions for expressions, we recommend that you do not use those suggestions as they cause incorrect behavior.
Snap Views
Type | Format | Number of Views | Examples of Upstream and Downstream Snaps | Description |
---|---|---|---|---|
Input |
Document
BinaryDocument |
|
|
Requires the EDI data and internal ID as a JSON document. | |
Output |
Document
BinaryDocument |
|
..
..
| Snap outputs the number of documents successfully inserted into the target table in the output view document. | |||
Error | Error handling is a generic way to handle errors without losing data or failing the Snap execution. You can handle the errors that the Snap might encounter when running the pipeline by choosing one of the following options from the When errors occur list under the Views tab:
Learn more about Error handling in Pipelines. |
Snap Settings
Info |
---|
|
Field Name | Field Type |
---|
Description | |
---|---|
Label* Default Value: |
Oracle - Parallel Load |
Oracle - Parallel Load | String |
None.
Specify the name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your pipeline. |
Schema name Default Value: |
fieldset Name
Specify advanced parameters that you want to include in the request.
Field 1*
Default Value: <value> or None.
Example: <value>
String
Debug mode check box is not selected.
Field 2
Default Value: <value> or None.
Example: <value>
String
N/A | String/Expression |
Sampling Type is Number of records.
Enter the number of records to output.
Specify the database schema name. You can pass the values as expressions using the Pipeline parameters but cannot use values from the upstream Snap. | ||
Table name* Default Value: N/A | String/Expression | Specify the table on which to execute the load operation. You can pass the values as expressions using the Pipeline parameters but cannot use values from the upstream Snap. |
Create table if not present Default Value: Deselected | Checkbox | Select this checkbox to automatically create the target table if it does not exist.
The newly created table is not visible to subsequent database Snaps during runtime validation because of implementation details. If you want to immediately use the newly updated data, you must use a child pipeline invoked through the Pipeline Execute Snap. |
Maximum thread count*
| Integer/Expression | Specify the maximum number of threads allowed to perform data insertions simultaneously. If the value is 0, the snap automatically sets the number of threads equal to the number of available processors on the system |
Batch capacity*
| Integer/Expression | Specify the maximum number of records allowed in a single batch for an insertion task. |
Maximum error count*
| Integer/Expression | Specify the maximum number of record insertion errors allowed before execution stops on the next error. For example, if you specify a value of 10, the pipeline execution continues as long as the number of failed records is less than 10. A value of -1 means no limit. At least one more error document than the specified maximum value is expected, but task concurrency may result in additional error documents. This applies only when the error behavior is set to Route Error Data to Error View. |
Truncate table before load
| Checkbox | Select this checkbox to truncate the target table before loading data. |
Snap Execution Default Value: | Dropdown list |
Select one of the following three modes in which the Snap executes:
|
Troubleshooting
Error | Reason | Resolution |
---|---|---|
Interrupted while waiting for dataWriter | dataWriter is still null | |
"Pre-load truncation of the target table failed"; | The target table may not exist, " + "or a database access error may have occurred when trying to execute the " + "TRUNCATE statement"; | Verify your database credentials and ensure the target table exists, then try again. |
Unable to determine target table " + "column names"; | Connection used to retrieve table metadata threw exception while closing"; |
Examples
Excluding Fields from the Input Data Stream
...