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.
How to join(merge) two sequential files?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I have tried for that but its not permitting me to link Seq file directly to Merge(in Palette->Merge)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.
it gives error "The destination stage does not support stram input links"
is Hashed file required inbetween?
No it does not work that way.Amar_nath wrote:I have tried for that but its not permitting me to link Seq file directly to Merge(in Palette->Merge)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.
it gives error "The destination stage does not support stram input links"
is Hashed file required inbetween?
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: