Mapping using Hashed file

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
prasad80
Participant
Posts: 8
Joined: Thu Jul 12, 2007 5:26 am

Mapping using Hashed file

Post by prasad80 »

Hi,
I am using a source file which has different columns like code1,code2,code3..and i have a XLS file which has code and description as columns. I need to design a job which can take the values from the XL file.
So what i am planning to do is extracting this XL file as a CSV run DS JOB and create a hash file. Planning to use this as a lookup file and map the column values.
But when i am trying to do this it is taking only the values which are read first ie., code2,code3 are getting the valuse of code1.

Can anyone suggest a process how to implement this with DS JOb.
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Show us the DataStage job design that you used, particularly the column metadata on both links.
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
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”