joining in server jobs

scorpion · Post by **scorpion** » Wed Feb 08, 2006 5:33 am

hi,

can any one please let me know how to join two or morethan two sources(flat file and database tables) in serverjobs.

we can have joinstage in parellel jobs..but how can we achieve in serverjobs.

thanx in advance
_________________
Thanx&Regards
scorpion

kumar_s · Post by **kumar_s** » Wed Feb 08, 2006 5:39 am

You have Merger in Server jobs.

-Kumar

scorpion · Post by **scorpion** » Wed Feb 08, 2006 5:51 am

hi kumar,
thanks for quick reply,i am really didnt find any merge stage in server jobs,can any one help me on this.
i already searched forum and manuals.but i am in confusing whether it is done by linkcollector stage...?
any one please help me out

tx in advance..
scorpion

kumar_s · Post by **kumar_s** » Wed Feb 08, 2006 5:57 am

Hi,
What is the version of DataStage you use?
If not in pallet, try to check in customize pallet.
Right click-> Customizaiton-> Customize->Processing --> Merge.

I guess its a plugin, check in DataStage CD as well.

-Kumar

scorpion · Post by **scorpion** » Wed Feb 08, 2006 5:57 am

sry gurus,

i got the answer,i think it will be done by universe stage or unidatastage!

tx

kumar_s · Post by **kumar_s** » Wed Feb 08, 2006 5:58 am

HI,

In server Editon, you can do a lookup even through a Transformer stage to acheive join of two files.

-Kumar

raj_konig · Post by **raj_konig** » Wed Feb 08, 2006 6:11 am

Code: Select all

In server Editon, you can do a lookup even through a Transformer stage to acheive join of two files.

I guess we can just do a lookup using a transformer but join is different with that of a lookup

rajesh

kumar_s · Post by **kumar_s** » Wed Feb 08, 2006 6:39 am

raj_konig wrote:
Code: Select all
In server Editon, you can do a lookup even through a Transformer stage to acheive join of two files. 
I guess we can just do a lookup using a transformer but join is different with that of a lookup

rajesh

Yes true. I never said both are same.
But you can still acheive the output of join through lookup (Inner, Leftouter, Right outer). The only constraint in lookup would be the lookup memory utilized during the process.

-Kukmar

Sreenivasulu · Post by **Sreenivasulu** » Wed Feb 08, 2006 8:25 am

Hi,

This could be of help:

One lookup each for satisfying each join condition.
There for suppose if you have 3 sources then you need to do use 2 lookups and 1 source. 2 lookups can be done using one transformer or
2 transformer depending on the logic.

Regards
Sreeni