DataStage - How to remove duplicates in server job

GeekInterview.com > Interview Questions > Data Warehousing > DataStage

Go To First | Previous Question | Next Question

DataStage | Question 173 of 377

How to remove duplicates in server job

Total Answers and Comments: 3

Last Update: August 07, 2006 Asked by: Priyanka

Sponsored Links

Best Rated Answer

—

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

May 26, 2006 11:12:06

Venkat

RE: How to remove duplicates in server job

1)Use a hashed file stage or
2) If you use sort command in UNIX(before job sub-routine), you can reject duplicated records using -u parameter or
3)using a Sort stage

Is this answer useful? Yes | No

June 01, 2006 00:58:06

Zabi81

Member Since: June 2006 Contribution: 4

RE: How to remove duplicates in server job

Hi,

Which stages u r using in the Server job. If u r using ODBC stage, then u can write User defined Query in the source stage.

If u need more details, i can explain u.

Is this answer useful? Yes | No

August 07, 2006 23:16:14

sudheermukkamalla

Member Since: August 2006 Contribution: 1

RE: How to remove duplicates in server job

Explain

Is this answer useful? Yes | No

Go To Top