Lookup not matching

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

kandyshandy
Participant
Posts: 597
Joined: Fri Apr 29, 2005 6:19 am
Location: Singapore

Post by kandyshandy »

I guess you should have approached it totally different. Just use a transformer and STAGE variables.

If your input file is not sorted, use a sort stage to sort it first.

If your input is from a table, do a SQL sort.. no need of hash file at all.
Kandy
_________________
Try and Try again…You will succeed atlast!!
Post Reply