Need little bit clarification on usage of Truncate and Load

vinodn · Post by **vinodn** » Wed Dec 19, 2007 6:27 am

Hi All,

I am using the following properties in my Oracle Stage.
Write Method = Load
Write Mode = Truncate

What would be sequence first Whether it truncate all the records first and then Load. Do we have any commit intervals using truncate and Load.

This clarification is needed as i got very less SLA time for processing the file which got around 6 GB of data.

Usually how much time would it take to load 6GB Data (Roughly 75 Million Records) running on 2 node machine

chulett · Post by **chulett** » Wed Dec 19, 2007 8:13 am

Of course, it would first truncate the table and then load everything. Then you have the standard APT environment variables to control the commit levels in Oracle.

You do know what 'truncate' does and the fact that it is... irreversible, yes?

ray.wurlod · Post by **ray.wurlod** » Wed Dec 19, 2007 3:32 pm

Truncate is a non-transactional operation that is very fast. As Craig notes, it occurs first and is irreversible.