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
- 20095 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
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Can you highlight the main features of ibm infosphere information server?
Define Routines and their types?
Define Data Stage?
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
What is the purpose of interprocessor stage in server jobs?
What is the difference between operational data stage (ods) and data warehouse?
What is use Array size in datastage
how to add a new records into source?
What is difference between server jobs & parallel jobs?
How many Key we can define in remove duplicate stage?
what is the use of surogate key in datastage
What are the stages in datastage?
Explain connectivity between datastage with datasources?
how to sort two columns in single job in datastage.
