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.
field mapping
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 132
- Joined: Wed Mar 01, 2006 11:12 pm
- Location: Pune
Re: field mapping
Hi dnat,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.
Unlike parallel jobs you need to specify columns in both the output and input tabs for a hash file. It doesnot comes automatically.
SMB
-
- Participant
- Posts: 132
- Joined: Wed Mar 01, 2006 11:12 pm
- Location: Pune
Re: field mapping
Hi dnat,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.
Unlike parallel jobs you need to specify columns in both the output and input tabs for a hash file. It doesnot comes automatically.
SMB