And we need to get the same multiple times records into the one target.
And single records not repeated with respected to dno need to come to one target.
Take Job design as
Read and load the data in sequential file.
In Aggregator stage select group =dno
Aggregator type = count rows
Count output column =dno_cpunt( user defined )
In output Drag and Drop the columns required.Than click ok
In Filter Stage
----- At first where clause dno_count>1
-----Output link =0
-----At second where clause dno_count<=1 -----output link=0 Drag and drop the outputs to the two targets. Give Target file names and Compile and Run the JOb. You will get the required data to the Targets.