This Snap has at most one document input view.

Expected input: The records to be deleted.

• Mapper
• Copy

This Snap has at most one document output view.

Expected output: If an output view is available, then the original document used to create the statement will be output with the status of the delete executed.

• N/A

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 Delete

Example: Delete contract emps

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: N/A

Example: SYS

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

Default value: N/A

Example: people

This is an expression property to specify the SQL WHERE clause of the delete statement. The delete condition may also be passed via an upstream Snap or through the pipeline parameters.

Default value: N/A

Examples without using expressions:

• EmpId = 12
• email = '[email protected]'

Examples using expressions:

• "EMPNO=$EMPNO and ENAME=$EMPNAME"
• email = $email
• emp=$emp
• "emp='" + $emp + "'"
• "EMPNO=" + $EMPNO + " and ENAME='" + $EMPNAME+ "'"

Specify the maximum number of attempts to make to receive a response. The request is terminated if the attempts do not result in a response.

Default value: 0

Example: 3

Specify the time interval between two successive retry requests. A retry happens only when the previous attempt resulted in an exception.

Default value: 1

Example: 10

Snap execution

Default value: Execute only

Example: Validate & execute