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 are the processing stages?
Can you highlight the main features of ibm infosphere information server?
What is the difference between the local container and shared container?
Can you explain engine tier in information server?
What is process model?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
options available in sequence job to run,validate?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What is merge stage?
Why do we use exception activity in Datastage?
Define Routines and their types?
How many types of hash files are there?
What steps should be taken to improve Datastage jobs?
how to export or import the jobs in .ISX file