- PowerCenter 10.5
- All Products
Location that contains the DLL or shared library.
Enter a path relative to the Integration Service node that runs the SQL transformation session.
If this property is blank, the Integration Service uses the environment variable defined on the Integration Service node to locate the DLL or shared library.
You must copy all DLLs or shared libraries to the run-time location or to the environment variable defined on the Integration Service node. The Integration Service fails to load the procedure when it cannot locate the DLL, shared library, or a referenced file.
Sets the amount of detail included in the session log when you run a session containing this transformation. When you configure the SQL transformation tracing level to Verbose Data, the Integration Service writes each SQL query it prepares to the session log.
Multiple partitions in a pipeline can use this transformation. Use the following options:
Default is No.
Update Strategy Transformation
The transformation defines the update strategy for output rows. You can enable this property for query mode SQL transformations.
Default is disabled.
The method in which the Integration Service applies the transformation logic to incoming data. Use the following options:
Set transaction scope to transaction when you use transaction control in static query mode.
Default is Row for script mode transformations.
Default is All Input for query mode transformations.
Output is Repeatable
Indicates if the order of the output data is consistent between session runs.
Default is Never.
The transformation generates transaction rows. Enable this property for query mode SQL transformations that commit data in an SQL query.
Default is disabled.
Requires Single Thread Per Partition
Indicates if the Integration Service processes each partition of a procedure with one thread.
Output is Deterministic
The transformation generates consistent output data between session runs. Enable this property to perform recovery on sessions that use this transformation. Default is enabled.