oracle enterprise stage

pongal · Post by **pongal** » Thu Sep 15, 2005 1:32 am

hi
i have a requirement such that we need to delete existing data on oracle database table and load new data for each job run.
what is the best approach where we can do delete and insert operations in the same job flow?
i didn't find any of the write options in oracle enterprise stage where we can do delete existing rows and insert new rows.
thanks in advance..

ray.wurlod · Post by **ray.wurlod** » Thu Sep 15, 2005 1:44 am

Use pre-SQL to execute TRUNCATE TABLE - it's much quicker.

pongal · Post by **pongal** » Thu Sep 15, 2005 3:59 am

thanks Ray
Where can i find pre sql option in oracle enterprise stage for truncating existing records and then insert new records

cmmurari · Post by **cmmurari** » Thu Sep 15, 2005 4:14 am

i think Mr.ray mean is in Oracle Enterprise Stage >Input tab> Properties tab>Target folder >one of Property is Write Mode is "Truncate"

You need to select Truncate property in Write Mode.

Ray ,please corret me if i am wrong.

Cheers,
Krishna