Check out the first Dataiku 8 Deep Dive focusing on Productivity on October 29th Read More

Update and Insert into existing oracle table

Level 1
Update and Insert into existing oracle table

Hi All

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

0 Kudos
3 Replies
Dataiker
Dataiker

Hi @Renga3037 

UPSERT operations are not graphically supported in DSS, however, you can still carry out these operations if you use a SQL recipe script option, see here for some info on how these work.

Good luck!

0 Kudos
Level 1
Author

@Liev 

Thanks for your suggestion.

What about existing table insert ? Any idea !

0 Kudos
Dataiker
Dataiker

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.

Or

You could do both in one go using an SQL recipe script type with UPSERT inside.

0 Kudos