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
how can we create rank using datastage?what is the meaning of rank?
How to find value from a column in a dataset?
Explain how a source file is populated?
What are the different types of lookups in datastage?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
What is a merge?
What is the difference between account and directory options ?
what is the difference between == and eq in UNIX shell scripting?
AGGREGATOR default datatype
Different ways a project can be moved to production ?...example ….export-import and Version control.
What are the types of containers?
Is possible to create skid in dim,fact tables?
what is use of SDR function?
How do you start developing a datastage project?
What is a merge in datastage?