DSXchange

Hello,

I have a requirement where in the sequence my first job would be to delete all the records from the table and the second job would load the data.

Is there a way that i can truncate the table as part of my first job rather than delete. If so which option should i use to truncate the table in the oracle enterprise stage.

thanks

As long as the table is actually 'truncatable' - privs, RI, etc - then it should just take putting the truncate command in the OPEN option of the OE stage to accomplish that, I do believe.

You can do this in the 'before job routine' as well.

Regards
Sreeni

Which would typically mean a scripted call to sqlplus.

Or an Open command in the Oracle Enterprise stage.

... which has already been mentioned.

If you want to truncate then why do it in first job.
you can do the same as well in second job either by using any of the solutions mentioned above or simply using the Load method with truncate option.