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
How one source columns or rows to be loaded in to two different tables?
What are the various kinds of containers available in datastage?
Highlight the main features of datastage?
What is the use of hoursfromtime() function in transformer stage in datastage?
How do you register plug-ins?
Is possible to create skid in dim,fact tables?
What is a folder? Difference types of stages?
Differentiate between validated and Compiled in the Datastage?
What is difference between join, merge and lookup stage?
Name the command line functions to import and export the DS jobs?
What are the types of jobs we have in datastage?
What is ds designer?
Explain connectivity between datastage with datasources?
EXPLAIN SCD
CHANGE CAPTURE