i have a some records
eno ename acono amount
1001 suresh sbi101 12000
1001 suresh sbi101 14000
1001 is dublicata how can i remove duplicate?
Answer Posted / venu
You can use Remove Duplicate Stage and select key
as 'eno'... now the out will be without duplicates...
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a merge?
How do you run datastage job from the command line?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What is a folder? Difference types of stages?
CHANGE CAPTURE
how to sort two columns in single job in datastage.
What is the difference between orabulk and bcp stages?
Highlight the main features of datastage?
How complex jobs are implemented in datstage to improve performance?
What all are the different way to run a job?
What are the types of jobs we have in datastage?
How to clean the datastage repository?
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 could be a data source system?
What is staging variable?