DSXchange

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

You have Merger in Server jobs.

-Kumar

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

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

sry gurus,

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

tx

HI,

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

-Kumar

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

rajesh

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

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