field mapping

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
dnat
Participant
Posts: 200
Joined: Thu Sep 06, 2007 2:06 am

field mapping

Post by dnat »

Hi,

I am new to server jobs. How do we map the fields from input to output in server jobs..In parallel, we have the Mapping tab where we drag the required fields from input to output.

In my job, i have

oracle table-->transformer1-->hashfile1-->transformer2-->hashfile2.

The output fields of transformer1 is shown in input of hashfile1, but not in output of hashfile1. I need those columns to take it to transformer2.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

On the columns grid of the input link, Save.
On the columns grid of the output link, Load from where you saved.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Or - inside transformer1, select all then copy. Open transformer2, paste.
-craig

"You can never have too many knives" -- Logan Nine Fingers
baglasumit21
Participant
Posts: 132
Joined: Wed Mar 01, 2006 11:12 pm
Location: Pune

Re: field mapping

Post by baglasumit21 »

dnat wrote:Hi,

I am new to server jobs. How do we map the fields from input to output in server jobs..In parallel, we have the Mapping tab where we drag the required fields from input to output.

In my job, i have

oracle table-->transformer1-->hashfile1-->transformer2-->hashfile2.

The output fields of transformer1 is shown in input of hashfile1, but not in output of hashfile1. I need those columns to take it to transformer2.
Hi dnat,
Unlike parallel jobs you need to specify columns in both the output and input tabs for a hash file. It doesnot comes automatically.
SMB
baglasumit21
Participant
Posts: 132
Joined: Wed Mar 01, 2006 11:12 pm
Location: Pune

Re: field mapping

Post by baglasumit21 »

dnat wrote:Hi,

I am new to server jobs. How do we map the fields from input to output in server jobs..In parallel, we have the Mapping tab where we drag the required fields from input to output.

In my job, i have

oracle table-->transformer1-->hashfile1-->transformer2-->hashfile2.

The output fields of transformer1 is shown in input of hashfile1, but not in output of hashfile1. I need those columns to take it to transformer2.
Hi dnat,
Unlike parallel jobs you need to specify columns in both the output and input tabs for a hash file. It doesnot comes automatically.
SMB
dnat
Participant
Posts: 200
Joined: Thu Sep 06, 2007 2:06 am

Post by dnat »

Thank you. I Saved the metadata and then loaded them in the output link.
Post Reply