duplicate records in sequential file
Moderators: chulett, rschirm, roy
duplicate records in sequential file
Hi friends
i am new to data stage, i have small problem pls solve
i have 3 sequential file file 1 , file 2, file 3
file 1 contains A, A records
file2 contains B, B records
file3 contains C, C records
my source is sequentiial file and target is sequential file.but output in target is A,B,C records. how can i eliminate duplicate records in sequential file, according to above example pls solve my problem
i am new to data stage, i have small problem pls solve
i have 3 sequential file file 1 , file 2, file 3
file 1 contains A, A records
file2 contains B, B records
file3 contains C, C records
my source is sequentiial file and target is sequential file.but output in target is A,B,C records. how can i eliminate duplicate records in sequential file, according to above example pls solve my problem
StageVariables are only helpfull if duplicate records follow one after the other, which could be easily done by fetching a DataBase-Table in a certain order. For flatfiles unless you know the a double is directly followed by one an other it is not adiquate.
Best is using Hashfiles, but for hash-files you have to know what you do. (READ THE MANUAL)
Wolfgang
Best is using Hashfiles, but for hash-files you have to know what you do. (READ THE MANUAL)
Wolfgang
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 232
- Joined: Sat May 07, 2005 2:49 pm
- Location: USA
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 232
- Joined: Sat May 07, 2005 2:49 pm
- Location: USA
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 232
- Joined: Sat May 07, 2005 2:49 pm
- Location: USA
Hi Sai,
Yes, I certainly agree that it is not the most efficient way to do it, but was just trying to see if it was theoritically possible. From the discussion we had, I can conclude that it is indeed possible to do it that way, but not very efficient. Thanks a lot for sharing your inputs on this issue.
Yes, I certainly agree that it is not the most efficient way to do it, but was just trying to see if it was theoritically possible. From the discussion we had, I can conclude that it is indeed possible to do it that way, but not very efficient. Thanks a lot for sharing your inputs on this issue.
Thanks,
Naveen
Naveen