I have two task to do.
1. I wanna update into existing table in oracle, is there any option to do that ?
2. Then I wanna insert into existing table in oracle, I saw the append instead of overwrite option but how to give the existing table in output ?
Please guide/Suggest the way
Thanks in advance
For task 1 you can use an SQL recipe script type with UPDATE inside.
For task 2 you can use a normal SQL recipe which will compute records and append new records if you have selected Append new records from the Input/Output tab of the recipe.
You could do both in one go using an SQL recipe script type with UPSERT inside.