Hi Guys,
I am trying to convert a server job to a parallel job.
In the server job, a lookup is made with a dummy column against a job variable.
The output of the lookup is that it will add one column with the same value to all the rows.
Could you somebody tell me as how to achieve this in parallel..
Thanks
Magesh
Lookup without a key column
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 126
- Joined: Thu Jul 01, 2010 11:39 pm
Lookup without a key column
Mac4rfree
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
either you can just pass that value as parameter to a column or create a record with row generator and use it to do lookup. You may need a transformer to set the values you require for that row if Defaulting in row generator cannot do that task.
If it doesn't look right, try explaining the situation, else its prone to different interpretation.
If it doesn't look right, try explaining the situation, else its prone to different interpretation.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
Re: Lookup without a key column
You can use column generator to generate the additional column for all the records and define the fixed value for that column
Nirdesh Kumar
-
- Premium Member
- Posts: 376
- Joined: Sat Jan 07, 2012 12:25 pm
- Location: Piscataway
Re: Lookup without a key column
I agree. I don't see the need for a look-up here. A column generator will suffice
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI