Hi All,
I am using 'import CSV to Database' smart service to import the data from CSV file to oracle data base, here data will be directly
importing to data base but this plugin won't perform updating.
Do I have any plugin to achieve this. i.e want to update the database values by Uploading the CSV file but I don't something like exporting them to CDT then inserting because my
data will be huge so if I follow this performance issues will come.
Thanks,
Bhargavi P
Discussion posts and replies are publicly visible
Hi Thank you for the information. But in my organisation using Query RDBMS smart service is not an allowed practice, but I could insert into temp table and invoke a stored procedure where that stored procedure will update the staging table into target table and truncate the staging table.
I will propose this way.