How to join(merge) two sequential files?

Amar_nath · Post by **Amar_nath** » Wed Apr 19, 2006 1:31 am

hi ,
i am new user of DS

I want to merge 2 seq files on a primary key

1st seq file contains - EmpName,EmpNo,Dept
2nd seq file contains - EmpNo,BasicSal

so i want a target file which contains-EmpName,EmpNo,Dept,BasicSal

reply soon.

ray.wurlod · Post by **ray.wurlod** » Wed Apr 19, 2006 1:43 am

Welcome aboard. :D

This is precisely the function of the Merge stage in server jobs. It can perform inner joins as well as outer joins.

Amar_nath · Post by **Amar_nath** » Wed Apr 19, 2006 1:56 am

ray.wurlod wrote:Welcome aboard. :D

This is precisely the function of the Merge stage in server jobs. It can perform inner joins as well as outer joins.

I have tried for that but its not permitting me to link Seq file directly to Merge(in Palette->Merge)

it gives error "The destination stage does not support stram input links"

is Hashed file required inbetween?

balajisr · Post by **balajisr** » Wed Apr 19, 2006 2:01 am

Amar_nath wrote:
ray.wurlod wrote:Welcome aboard. :D

This is precisely the function of the Merge stage in server jobs. It can perform inner joins as well as outer joins.
I have tried for that but its not permitting me to link Seq file directly to Merge(in Palette->Merge)

it gives error "The destination stage does not support stram input links"

is Hashed file required inbetween?

No it does not work that way.
It does not accept input link. It can have output link only.

Merge Stage ---> Sequential File Stage

Did you check Merge stage properties through which you can specify 2 filenames to be merged and also their respective column definitions. You can specify type of join like inner join, complete set etc..

I suggest you read the manual for better understanding.

ray.wurlod · Post by **ray.wurlod** » Wed Apr 19, 2006 4:13 am

You name both input files within the Stage properties. The Merge stage only has an output link.