DataStage - How do you remove duplicates without using remove duplicate stage?

GeekInterview.com > Interview Questions > Data Warehousing > DataStage

Go To First | Previous Question | Next Question

DataStage | Question 222 of 377

How do you remove duplicates without using remove duplicate stage?

Total Answers and Comments: 4

Last Update: September 05, 2006 Asked by: Reddy

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

August 03, 2006 02:06:33

sasi

RE: How do you remove duplicates without using remove ...

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

Is this answer useful? Yes | No

August 03, 2006 21:16:10

Reddy

RE: How do you remove duplicates without using remove ...

Could please explain about this?

Thanks

Sudheer.

Is this answer useful? Yes | No

August 11, 2006 03:11:21

Tasneem

RE: How do you remove duplicates without using remove ...

Using a sort stage,set property: ALLOW DUPLICATES :false

Is this answer useful? Yes | No

September 05, 2006 03:48:34

RE: How do you remove duplicates without using remove ...

You can do it at any stage.

Just do a hash partion of the input data and check the options Sort and Unique.

This will do.

Is this answer useful? Yes | No