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

nitijosh

 Profile Answers by nitijosh Questions by nitijosh

• Nov 22nd, 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.

spagidi

 Profile Answers by spagidi Questions by spagidi

• Sep 14th, 2009

SQL Transformation drops any incoming transaction boundaries

Answer Question  Select Best Answer

Why the input pipe lines to the joiner should not contain an update strategy transformation?

vijayant.sanjay

 Profile Answers by vijayant.sanjay Questions by vijayant.sanjay

• Sep 7th, 2011

Joiner will join two groups of data either homogeneous or heterogeneous, and this join will happen horizontally. One scenario why use of update strategy is prohibited upstream of joiner t/f as below ...

Etl Developer

 Profile Answers by Etl Developer Questions by Etl Developer

• May 28th, 2010

This scenario is illogical, First we need to understand the functionality of each repository object.Update strategy: This transofrmation is used to maintain the transaction data based on differen...

Answer Question  Select Best Answer

In which situation do we use update strategy?

Anil

• Jun 22nd, 2016

If we want to perform 2 DML operations but same operations it is not better to use update tr. use property in session (treat source rows as) instead of creating update tr. If we want to perform 2 DML...

ankit

• May 4th, 2016

Can any one tell me in which scenario it is not advisable to use update strategy?

Answer Question  Select Best Answer