Out execution order

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

Post Reply
ranga1970
Participant
Posts: 141
Joined: Thu Nov 04, 2004 3:29 pm
Location: Hyderabad

Out execution order

Post by ranga1970 »

Do we have any option to select the out execution order

Code: Select all



      --------link1-------------
XFM -------link2--------------ora
      ---------link3-------------
I have three link from transformer to ora, if have an execution order set the order link1, link2, link3 does the insertion happen in the same order
actually link1 is delete, link2 is insert, link3 is update , i whant it to happen in the same order, does the execution order take care of that?

If yes, do have to specify execution order or it is automatically set??? any help is appreciated, thanks
RRCHINTALA
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

Open the transformer stage, go to the top menu bar, on the right side is a button for output link order. Set the order you need.

Be careful if you're attempting to group rows in a single commit. Read the manual for the conditions to make this work.
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Post Reply