Performance
Posted: Wed Jan 11, 2012 9:42 pm
Hi,
We are loading data from a sequential file to oracle and volume is 650 millions of records. It took 45 hours to load 318 million records, performance wise it's very poor. Job design is like this
in transformer we are using a transformation rule to check for spaces(4 columns) move to one oracle enterprise stage other move to another oracle stage.
we are using oracle load options as direct = false, parallel = true.
in oracle enterprise stage
write method = load
write mode = append
Please help us to improve performance.
Thanks in advance.
We are loading data from a sequential file to oracle and volume is 650 millions of records. It took 45 hours to load 318 million records, performance wise it's very poor. Job design is like this
Code: Select all
sequential file --> transformer --> oracle enterprise stage
|
V
oracle enterprise stage
we are using oracle load options as direct = false, parallel = true.
in oracle enterprise stage
write method = load
write mode = append
Please help us to improve performance.
Thanks in advance.