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!
As per my understanding you want to truncate the table before it starts loading..In session use Truncate table statement in the PRESQL under target properties.
Please let me know if my understanding is wrong.
Hi Larry ,
There are 2 ways by which we can do this
the main point is to find when to truncate the target table
1: On the starting point of session/workflow
A) Using per sql at pre source/target level as Sasiramesh said
B) Using stored procedure at pre source/target level
C) Using a SQL transformation in the starting of the flow with proper condition check
2: Writing script in the external load to truncate the target table before loading
Note: On point 2 you need to investigate the feasibility