Need little bit clarification on usage of Truncate and Load
Posted: 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
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