Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 20995 Views
- Bank Of America, IBM, I also Faced
- E-Mail Answers
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
explain about citrix scheduling tool in datastage
What are the steps required to kill the job in Datastage?
How and where you used hash file?
Define Data Stage?
Why do we use exception activity in Datastage?
What are the different plug-ins stages used in your projects?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What are the main differences you have observed between 7.x and 8.x version of datastage?
Demonstrate experience in maintaining quality process standards?
What are sequencers?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
Differentiate between odbc and drs stage?
Does datastage support slowly changing dimensions ?
What are some different alternative commands associated with "dsjob"?
how do u catch bad rows from OCI stage? And what CLI stands for?
