ihave an reqirement with some destructive tables(data which is not incremental),so each and every time i need to truncate the data in table and then it should be loaded.i dont have replace privilages wit in the datastage,so far i create three jobs
1)delete data into table
2)load data as per reqirement
3)sequence to call above two jobs
now what i plan to do,i want to prepare one sql script for truncate table data and then load the freshdata.
i design the sequence job somehing like
Code: Select all
routineactivity(to call sequel script and job activity(call load job)