DataStage - Remove Duplicates

GeekInterview.com

I am new, Sign me up!

GeekInterview.com > Tech FAQs > DataStage

Go To First | Previous Question | Next Question

DataStage | Question 103 of 140

Print

Remove Duplicates

How to remove duplicates in datastage?

Total Answers and Comments: 5

Last Update: June 22, 2008 Asked by: vasanthsolai

Sponsored Links

Best Rated Answer

—

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

March 19, 2008 07:25:22

#1

Member Since: October 2007 Contribution: 1

RE: Remove Duplicates

Hi

We have the remove duplicate stage in the pararllel extender enterprise edition using that we eill remove the duplicates
(or)
Using copy stage we will remove the duplicates.

Is this answer useful? Yes | No

March 19, 2008 23:59:30

#2

Member Since: November 2007 Contribution: 15

RE: Remove Duplicates

make the wanted column as key column in target stage.
Then it will remove the duplicates.

Is this answer useful? Yes | No

April 13, 2008 10:17:46

#3

Member Since: May 2006 Contribution: 7

RE: Remove Duplicates.

What is the process to remove the duplicates in copy Stage?

Is this answer useful? Yes | No

May 09, 2008 03:09:09

#4

Member Since: May 2008 Contribution: 10

RE: Remove Duplicates

In parallel jobs by using sort stage Or Remove Duplicates stage We can remove duplicate records

Regards
Suri

Is this answer useful? Yes | No

June 22, 2008 08:51:22

#5

Member Since: June 2008 Contribution: 2

RE: Remove Duplicates

There are several ways in removing the duplicates depends on the data u have..

have to use stage variables effectively to remove the duplicates.

use rowprevious compare function.. which is available in datastage...

Regards
Sriks

Is this answer useful? Yes | No

Sponsored Links

About Us - Privacy Policy - Terms and Conditions - Contact - Ask Question - Propose Category - Site Updates

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved