In the target make the column as the key column and run the job.

hi , by using sort stage we remove duplicates as making options allow duplicates= false.

we can run the job without using the removedublicates stage.
In the sort stage we have one option that is allow dublicates=false,if you set allow dublicates=true,dublicate records also moves from source to target.

By using aggregator stage and transformer stage. Use the aggregator stage and group the column. In the transformer stage, use if then else condition and count(column)>1 then duplicates else no duplicates.

By using the merge stage we can remove the dublicates of the source data.Target will capture the unique records of the source, It won't allow the dubilcates

If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code:*
	Inform me about updated answers to this question