DSXchange

hi all,
The DBA in our shop does not allow the etl generic id to truncate the table before loading. We have to 'truncate' and load the staging tables.

Is there a way to execute a stored procedure from the ODBC stage before loading the Oracle staging tables?

Thanks

wouldn't a script be more efficient?

write a script to truncate the table. use the sequencer stage to call the script and do the rest of sequencer upon successfull completion of this job.

hmm..we do not have the oracle client installed on the OS