How to control Transactions
Posted: Fri Dec 17, 2010 5:23 pm
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?
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?