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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
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.