Skip navigation
Contact Us
2228 Views 2 Replies Latest reply: Oct 8, 2011 12:57 PM by Ravikumar Sanjeevi RSS
Larry Gale Newbie 10 posts since
Mar 24, 2011
Currently Being Moderated

Oct 7, 2011 8:00 AM

Truncate target table after reading source but before running external loader?

I have a workflow that's reading from a relational source (Sybase ASE) and loading the target (Sybase IQ) through an external loader. I know that I can configure a workflow to truncate the target tables before reading the source tables, but I want to minimize the time interval where my target tables are empty.

 

So, is there a way to configure a workflow to NOT truncate the target database tables until immediately before the external loader begins loading? That would reduce the time that my target relational tables are empty to a matter of seconds, rather than several minutes.

 

Thanks for any suggestions!

More Like This

  • Retrieving data ...

Bookmarked By (0)