Just a small question about sorting order and lookup...

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
kaps
Participant
Posts: 452
Joined: Tue May 10, 2005 12:36 pm

Just a small question about sorting order and lookup...

Post by kaps »

I have a small question about the sort order and lookup. Lets say I have sorted order of records going through a transformer and does look up.
In the constraints I have mentioned Not(LKPNotFound) so some records will be dropped.

My assumption here is that the order coming out of transformer will be same as the order came into the tranformer even though there may be a less number of records coming out of it.

I would like someone to verify this statement.

Appreciate the help.

Thanks
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Consider it verified. A Server job cannot re-order records in a Transformer stage.
-craig

"You can never have too many knives" -- Logan Nine Fingers
kaps
Participant
Posts: 452
Joined: Tue May 10, 2005 12:36 pm

Post by kaps »

Thanks a lot...Craig...
Post Reply