DataStage - How can we remove duplicates using sort stage?

GeekInterview.com > Interview Questions > Data Warehousing > DataStage

Go To First | Previous Question | Next Question

DataStage | Question 297 of 390

How can we remove duplicates using sort stage?

Total Answers and Comments: 3

Last Update: June 22, 2009 Asked by: sivanov21

Sponsored Links

Best Rated Answer

—

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

February 09, 2007 14:47:31

Vikas

RE: How can we remove duplicates using sort stage?

Set the Allow Duplicates option to false

Is this answer useful? Yes | No

February 28, 2007 16:43:48

Alex

RE: How can we remove duplicates using sort stage?

TreeSet<String> set new TreeSet<String>(Arrays.asList(names));
for (String name : set)
System.out.println(name);

this is enough for sorting and removing of duplicate elements (using Java 5 in this example)

Is this answer useful? Yes | No

June 22, 2009 05:57:38

vadlamudi225

Member Since: June 2009 Contribution: 1

RE: How can we remove duplicates using sort stage?

In the Sort Stage properties set Allow Duplicates False

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank