Oracle Stage Truncate & load

vick · Post by **vick** » Tue Apr 03, 2007 10:13 am

Hi,

Is it possible to truncate and load the table in the same job.

This is the design I have now. I have the load option selected in the Oracle Enterprise Stage. I truncate the table through TOAD before I load.

Code: Select all


Seq_File---------->BusinessRules--------->Oracle_table

How can I include the truncate option in the same design?

TIA

DSguru2B · Post by **DSguru2B** » Tue Apr 03, 2007 10:21 am

You can provide the truncate command in OPEN command. Its synonymous to before sql in OCI stage.

ray.wurlod · Post by **ray.wurlod** » Tue Apr 03, 2007 10:46 pm

Set the Write method to Load and the Write mode to Truncate.