one file contains
col1
100
200
300
400
500
100
300
600
300
from this i want to retrive the only duplicate like this
tr1
100
100
300
300
300 how it's possible in datastage?can any one plz explain
clearley..........?
Answer Posted / chandu
use aggregator and calculate count of source column after
that use filter or transaformer stage use condition as count
>1 it gives only duplicate records
Thanks
Chandu-9538627859
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is the project in datastage?
What are the types of containers?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What a datastage macro?
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 developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Name the different sorting methods in datastage.
what is the difference between == and eq in UNIX shell scripting?
What are the primary usages of datastage tool?
How rejected rows are managed in datastage?
describe the Steps to confiure a Qlogic switch
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What are the functionalities of link partitioner and link collector?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
How do you run datastage job from the command line?