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.