Hi good people,
I'm new to spoon and I've been using Holowczack's tutorials to get a feel of how PDI works. I have a scenario where I would like to run an update script after a table input and table output job, can anyone assist? I have tried these four but I can't seem to figure out how to make them work.
Here's the scenario...
Table Input: MySQL Database Table1 (Select * from Table1)
Table Output: Oracle Database (Create Table 1)
(this runs well to completion but then I have to execute the update script manually. I am looking for a way to automate this)
Intended Update Script:
update ods.table1 set colum1='New Value1' where column1='Old Value1'
update ods.table1 set colum1='New Value2' where column1='Old Value2'
Thank you in advance.