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
Need little bit clarification on usage of Truncate and Load
Moderators: chulett, rschirm, roy
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?![Confused :?](./images/smilies/icon_confused.gif)
You do know what 'truncate' does and the fact that it is... irreversible, yes?
![Confused :?](./images/smilies/icon_confused.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: