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 / subhash
According his logic: from aggregator stage: the output is
this: 251,2
456,2
951,1
985,1
the main data is:
251
251
456
456
951
985
If you join these two links then the output will be:
251,2
251,2
456,2
456,2
951,1
985,1
Then your are specifying that count=1 then you get the
unique records. means YOU get: 951,985
in another link count<>1 means YOU get: 251,
251,
456,
456
this is our desired out put, our out put.
the logic explained by Shiva is correct.
Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is process model?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What is the flow of loading data into fact & dimensional tables?
What are the components of datastage?
Differentiate between operational datastage (ods) and data warehouse?
what are the devoleper roles in real time? plz tell i am new to datastage....
What are data elements?
Describe routines in datastage? Enlist various types of routines.
Why fact table is in normal form?
What is the use of datastage director?
How many Key we can define in remove duplicate stage?
options available in sequence job to run,validate?
what is the use of surogate key in datastage
Explain ibm infosphere information server and highlight its main features?