Execute file with multiple SQL queries

user12863665

I would like to execute multiple sql queries(delete statements on different tables) as part of ODI package.

Anyone suggest me how can I do that with simple way in ODI.

Adrian_Popescu-Oracle

Hi,

Create an ODI procedure and add a task based on Oracle technology.

The code will be:

begin

delete from .....;

insert into ..........;

end;

user12863665

Thank you the advice.Is there a way I can pick the file path instead of hardcoding these statements.

intention is to update the statements in the file. Automatically ODI package has to execute those sql statements.

SH_INT

If you want dynamic file paths try using ODI variables in combination with the Options that can be set on the ODI Procedure