How to capture duplicate reject row in the sequential file

[arasan]

can any one tell how to capture the duplicate reject rows in the sequential file.

for example

source

rollno,name
101,pradeep
102,arasan
101,deepu

in the reject i should get one row after implementing the hob design through datastage.

[wnogalski]

Store the Rejects in a HashedFile with key column set to rollno but this way you will only get the last version of rejected row with given rollno.

[arasan]

i tried that but i am unable to capture the reject rows

source(SF)----->transformer----->hashfile
(reject hash file)

if i mplement the job design as this way i am not able to capture the rejected row.After the trasformer the rows from soure are passing directly to the target hash file.but when i view data in hash file i am getting two rows only.I know that hash file is doing is Job but the other rows that is not shoing in the hash file i need to capture it.

If i am wrong pls correct me....

[ray.wurlod]

By "reject" do you mean "duplicate"?

[WoMaWil]

as Ray already said is, that we need more information, what you finally want to reach. Rejects and Removing Dublicates is a strength of DataStage.

Only if we knew, what you finally want, we can give you a good solution.

[arasan]

hi ray i want the duplicate row from the source sequential file to be captured .

[wnogalski]

Count the rollno's using Aggregator and then filter the ones with count > 1.

[DSguru2B]

Check out this post. In this post Craig elaborates a method thats taught by IBM to capture duplicates.

[wnogalski]

That's a really smart - thanks for the tip DSguru2B