Page 1 of 1
How to join(merge) two sequential files?
Posted: Wed Apr 19, 2006 1:31 am
by Amar_nath
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.
Posted: Wed Apr 19, 2006 1:43 am
by ray.wurlod
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.
Posted: Wed Apr 19, 2006 1:56 am
by Amar_nath
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?
Posted: Wed Apr 19, 2006 2:01 am
by balajisr
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.
Posted: Wed Apr 19, 2006 4:13 am
by ray.wurlod
You name both input files within the Stage properties. The Merge stage only has an output link.