one file contains
col1
100
200
300
400
500
100
300
600
300
from this i want to retrive the only duplicate like this
tr1
100
100
300
300
300 how it's possible in datastage?can any one plz explain
clearley..........?
Answer Posted / reddyvaraprasad
Job Design:
|----->Agg--->Filter1-->|
| |
| |
file-->cp-------------------->Join---->Filter2---->target
Agg: use aggregator and select Agg_type=count rows and then give the Count O/P column=Count (User defined).
Filter1: give the condition Count<>1
Join: select left outer join
Filter2: give the condition Count<>0
u will get the right output....what ever the duplicate records.
and if u want unique records, give the condition Count=0
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
Describe the architecture of datastage?
What is the roundrobin collector?
What is "fatal error/rdbms code 3996" error?
What are the types of containers in datastage?
Define orabulk and bcp stages?
What is apt_config in datastage?
how many rows sorted in sort stage by default in server jobs
How do you register plug-ins?
What is the project in datastage?
Why fact table is in normal form?
Terminate Activity
how to implement scd2 in datastage 7.5 with lookup stage
Differentiate between Join, Merge and Lookup stage?
Define Merge?