Home
|
Tech FAQ
|
Interview Questions
|
Placement Papers
|
Tech Articles
|
Learn
|
Freelance Projects
|
Online Testing
|
Geeks Talk
|
Job Postings
|
Knowledge Base
|
Site Search
|
Add/Ask Question
GeekInterview.com
>
Tech FAQs
>
DataStage
Go To First
|
Previous Question
|
Next Question
DataStage
| Question 103 of 118
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
santsg
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
nagoosk
Member Since: November 2007 Contribution: 14
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
venkata ramana
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
Suri123
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
dwh_com
Member Since: June 2008 Contribution: 0
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
Go To Top
Sponsored Links
Related Categories
—
Abinitio FAQs
AJAX FAQs
Concepts FAQs
Data Warehousing FAQs
Database FAQ
DataStage FAQ
Informatica FAQ
LoadRunner FAQ
Lotus Notes FAQ
Mainframe FAQs
Networking FAQ
OOPS FAQ
Operating System FAQ
Oracle FAQs
Oracle Apps FAQs
PeopleSoft FAQs
PL/SQL FAQ
Programming Faqs
QTP FAQ
Rational Robot FAQ
RDBMS FAQs
SAP R/3 FAQs
Scripting FAQs
Siebel FAQ
SilkTest FAQs
Oracle SQL FAQ
SQL Server FAQs
Test Director FAQ
Testing FAQs
Testing Definitions
Websphere FAQ
WinRunner FAQ
DataStage FAQ Related
—
Latest Questions
Open Questions
Fileset
What is the difference between ODBC and OCI stage in server job
Write query for removing duplicates in source stage
Can we pass the parameters in job sequence
Datastage job is aborted at any time what we will do
What is lately arrive dimension
SQL Sever Stored Procedure
Filter and External Filter stages
BASIC Transformer and NORMAL Transformer
How the job status changed when the datasets it process is locked by another job
Sponsored Links
Sponsored Links
About Us
|
Privacy Policy
|
Terms and Conditions
|
Contact
|
Site Map
|
Add Question
|
Propose Category
|
RSS Feeds
|
Articles Sitemap
|
Site Updates
|
Add Resource
Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
