Transaction Control

Explain Why it is bad practice to place a Transaction Control transformation upstream from a SQL transformation?

Questions by krish_80   answers by krish_80

Showing Answers 1 - 2 of 2 Answers

nitijosh

  • Nov 21st, 2009
 

First Thing as mentioned in the Other Posts it drops all the incoming transaction control boundries.
Besides you can use Commit and Rollback statements within SQL Transformation Script to control the transactions, thus avoiding the need for the Transaction Control Transformation.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions