Extremely slow Oracle Loading

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

gateleys
Premium Member
Premium Member
Posts: 992
Joined: Mon Aug 08, 2005 5:08 pm
Location: USA

Post by gateleys »

Thanks for the tremendous amount of responses guys. Like what most of you pointed out, the slowness was due to the various constraints applied to the target table. Once I had them disabled, it just took seconds to load.

Thanks ... all of you.
Post Reply