Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

FAQ: How does the SQL Transformation commit data?
Answer

The SQL transformation commits data depending on if the of database connection is dynamic or static.

Dynamic database connection

If the connection is a dynamic database connection the Integration Service issues a commit after executing the SQL for each input row.

Static database connection

If the connection is a static connection the Integration Service issues a commit after processing all the input rows. The transaction includes all the database rows to update.
When using a static connection, if the session fails due to some error in another transformation after the SQL transformation the Integration Service will issue a commit and there will be no option to rollback the changes.A feature request (CR 175658) has been created to provide the option to rollback the changes if session fails.


More Information

Applies To
Product: PowerCenter
Problem Type:
User Type: Developer
Project Phase:
Product Version: PowerCenter 8
Database:
Operating System:
Other Software:

Reference
PowerCenterTransformation Guide "SQL Transformation" Chapter > "Session Processing"> "Transaction Control"
CR 175658

Attachments

Last Modified Date:8/2/2008 4:14 PMID:23063
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)