GeekInterview.com
Series: Subject: Topic:
Question: 176 of 1131

Transaction Control

Explain Why it is bad practice to place a Transaction Control transformation upstream from a SQL transformation?
Asked by: krish_80 | Member Since Aug-2009 | Asked on: Aug 21st, 2009

View all questions by krish_80   View all answers by krish_80

Showing Answers 1 - 2 of 2 Answers
spagidi

Answered On : Sep 14th, 2009

View all answers by spagidi

SQL Transformation drops any incoming transaction boundaries

Yes  1 User has rated as useful.
  
Login to rate this answer.
nitijosh

Answered On : Nov 21st, 2009

View all answers by nitijosh

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.

Yes  1 User has rated as useful.
  
Login to rate this answer.

Give your answer:

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

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.