Data Integration
- Data Integration
- All Products
Property
| Description
|
---|---|
Tracing Level
| Detail level of error and status messages that
Data Integration writes in the session log. You can choose terse, normal, verbose initialization, or verbose data. Default is normal.
|
Subsecond Precision
| Subsecond precision for datetime fields. You can change the precision for databases that have an editable scale for datetime data.
If you enable SQL ELT optimization, the database returns the complete datetime value, regardless of the subsecond precision setting.
Enter a positive integer value from 0 to 9. Default is 6 microseconds.
|
Stored Procedure Type
| For unconnected transformations, determines when the stored procedure
runs. Select one of the following options:
When the SQL transformation is
part of a mapplet, the stored procedure type is always
Normal. |
Call Text
| For unconnected transformations with stored procedure type Target
Pre/Post Load or Source Pre/Post Load, enter the call text for the
stored procedure. The call text is the stored procedure name
followed by the input parameters in parentheses. If there are no
input parameters, you must include an empty pair of parentheses.
Do not include the SQL statement EXEC or use the :SP keyword.
The call text does not apply to Normal stored procedure
types. |
Property
| Description
|
---|---|
Behavior
| Transformation behavior, either active or passive.
If active, the transformation can generate more than one output row for each input row. If passive, the transformation generates one output row for each input row.
Default is Active.
|
Continue on SQL Error within Row
| Continues processing the remaining SQL statements in a query after an SQL error occurs.
Enable this option to ignore SQL errors in a statement.
Data Integration continues to run the rest of the SQL statements for the row. The SQL transformation does not generate a row error, but the SQLError field contains the failed SQL statement and error messages.
Disable this option to debug database errors. Otherwise, you might not be able to associate errors with the query statements that caused them.
Default is disabled.
|
Auto Commit
| Enables auto-commit for each database connection.
Each SQL statement in a query defines a transaction. A commit occurs when the SQL statement completes or the next statement is executed, whichever comes first.
Default is disabled.
|
Max Output Row Count
| The maximum number of rows that the SQL transformation can output from a SELECT query.
To configure unlimited rows, set this property to zero. Default is 600.
|
Tracing Level
| Detail level of error and status messages that
Data Integration writes in the session log. You can choose terse, normal, verbose initialization, or verbose data. Default is normal.
|
Transformation Scope
| The method in which
Data Integration applies the transformation logic to incoming data.
Select one of the following options:
Default is Row.
|