Data Integration
- Data Integration
- All Products
Scenario
| SQL transformation type
|
---|---|
Run a stored procedure before or after a mapping.
| Unconnected
|
Run a stored procedure once during a mapping.
| Unconnected
|
Run a stored procedure every time a row passes through the SQL transformation.
| Connected or unconnected
|
Run a stored procedure based on data that passes through the mapping such as when a specific field does not contain a null value.
| Unconnected
|
Pass parameters to the stored procedure and receive a single output parameter.
| Connected or unconnected
|
Pass parameters to the stored procedure and receive multiple output parameters.
To get multiple output parameters from an unconnected SQL transformation, you must create variables for each output parameter.
| Connected or unconnected
|
Run nested stored procedures.
| Unconnected
|
Call a stored procedure multiple times within a mapping.
| Unconnected
|