Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
pongal
Participant
Posts: 77 Joined: Thu Mar 04, 2004 4:46 am
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
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Sep 15, 2005 1:44 am
Use pre-SQL to execute TRUNCATE TABLE - it's much quicker.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
pongal
Participant
Posts: 77 Joined: Thu Mar 04, 2004 4:46 am
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
Participant
Posts: 34 Joined: Sun Jan 02, 2005 9:55 am
Location: Singapore
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