i want send my all duplicate record one tar and all uniq
records one target how we will perfome explain
example:
input data
eid
251
251
456
456
951
985
out put/target1
251
251
456
456
out put/target2
951
985
how we will bring
Answer Posted / vinod upputuri
Appreciate your Answer but it was wrong..because if you are using Agregator stage it will give only unique records with record count. so how can u print all the duplicate records.
in the above senario:
input to agregator stage: 251,251,456,456,951,985
i used count rows.
so, the o/p is 251,2
456,2
951,1
985,1
if U use the Filter stage then what is the output:
O/P1:
251
456
O/P2:
951
985
Unfortunately this is not the answer we are required...
This is not as simple as U think...i implemented it before posting!!!!!
Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
Can you define merge?
What is merge stage?
In Datastage, how you can fix the truncated data error?
What are the various kinds of the hash file?
Is the value of staging variable stored temporarily or permanently?
how to export or import the jobs in .ISX file
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What are the components of ascential data stage?
How do u convert the columns to rows in datastage?
describe the Steps to confiure a Qlogic switch
sed,awk,head
Describe routines in datastage? Enlist various types of routines.
How to convert RGB Value to Hexadecimal values in datastage?
What is "fatal error/rdbms code 3996" error?
Describe stream connector?