Hi This is Vijay,
How can your remove the duplicates in sequential File?
Answer Posted / manoj
By using "DISTINCT" key word can remove all the duplicates
in the record or file .......
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What is difference between join, merge and lookup stage?
What is the difference between datastage and datastage tx?
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 ?
how to sort two columns in single job in datastage.
What are routines in datastage? Enlist various types of routines.
how to implement scd2 in datastage 7.5 with lookup stage
How to convert RGB Value to Hexadecimal values in datastage?
What is the difference between informatica and datastage?
Demonstrate experience in maintaining quality process standards?
What a datastage macro?
what is the custome stage in datastage? how can we impliment that one? plz tell me
Can you highlight the main features of ibm infosphere information server?
Have you used Unstructured data?
Describe link sort?