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
Explain the situation where you have applied SCD in your project?
How can we improve performance of data stage jobs?
What are the types of hashed files in data stage
How to clean the datastage repository?
What is active and passive stage?
Where do you see different stages in the designer?
How do you reject records in a transformer?
What are the components of datastage?
What is a merge?
Name the different types of Lookups in Datastage?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What is the difference between in process and inter process?
How complex jobs are implemented in datstage to improve performance?
What is the difference between orabulk and bcp stages?
sed,awk,head