How to control Transactions

[svhari76]

Hi All,

Can some one through some information on how i can control the datastage when to commit the transcation.

Example: Lets say we have flight table and passenger table and if i want to commit the data for each flight with all the passenger information at once(2 different tables, one transaction and up on change of flight i need to commit), how can i do that?

[ray.wurlod]

Use "grouped transaction" in an ODBC stage with multiple input links.