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
- 13 Answers
- 16943 Views
- Bank Of America, IBM, I also Faced
- E-Mail Answers
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 difference between server jobs & parallel jobs?
How will you move hashed file from one location to another location?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What are the difference types of stages?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
how to export or import the jobs in .ISX file
in oracle target stage when we use load option and when we use upsert option?
What are the steps required to kill the job in Datastage?
Why fact table is in normal form?
Explain usage analysis in datastage?
Describe link sort?
What are the repository tables in datastage?
Whats difference betweeen operational data stage (ods) and data warehouse?
What is the roundrobin collector?
