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
Lookup constraints
What is the sortmerge collector?
How and where you used hash file?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What is job control?
how to write server Routine coding?
Have you used Unstructured data?
What is active and passive stage?
How to reverse the string using SQL?
Highlight the main features of datastage?
What is "fatal error/rdbms code 3996" error?
how to implement scd2 in datastage 7.5 with lookup stage
How rejected rows are managed in datastage?