truncate issue in oracle stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

What are your property settings for the (presumably) Oracle Enterprise stage?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
ovidiu
Premium Member
Premium Member
Posts: 22
Joined: Tue Dec 20, 2005 7:14 pm

Post by ovidiu »

Oracle Enterprise Stage Properties:
Write Method: Load
Write Mode: Truncate

Options
Disable Constrains=False

Index Mode=Rebuild
add compute statistics=true
add nologging=true

drop columns not in table=false
truncate column names=false

Thank you,

Ovidiu
ovidiu
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”