Stored Proceudure from OBDC stage

Apotluri · Post by **Apotluri** » Tue May 27, 2008 10:43 am

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

Madhavan VM · Post by **Madhavan VM** » Tue May 27, 2008 2:18 pm

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.

Apotluri · Post by **Apotluri** » Tue May 27, 2008 2:26 pm

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