Basically we are loading from Sybase to Oracle tables, it takes close to 30 mins. for loading 2 million records. It is direct mapping and no validation.
For the first run it will be full referesh but then onwards it would be delta records. Hence we are using a upsert process (Update then insert)
SYB -> TRN -> ORA
Apart from this when we add a column to the existing record and load the overall load time for 2 million records is 1 hour.
Any suggestions on how to bring the load time down please.
Thanks
Performance Issue
Moderators: chulett, rschirm, roy
Ask your oracle dba to drop indexes and turn off logging for the first run. once your run is complete, ask him to recreate the indexes and turn logging back on and perform a reorg. That should speed up your process.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Premium Member
- Posts: 120
- Joined: Thu Oct 28, 2004 4:24 pm
-
- Premium Member
- Posts: 120
- Joined: Thu Oct 28, 2004 4:24 pm