Hi This is Vijay,
How can your remove the duplicates in sequential File?
Answer Posted / arun
Sort the incoming data using a sort stage & use remove
duplicates on the key columns. This will remove the
duplicates in ur source file.
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
What are the functionalities of link partitioner?
How many types of sorting methods are available in datastage?
How to read the length of word in unix?
Could anyone give brief explanation bout datastage admin
Difference between in process and inter process?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
Give an idea of system variables.
What is active and passive stage?
How complex jobs are implemented in datstage to improve performance?
How a server job can be converted to a parallel job?
Can you explain link buffering?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Distinguish between informatica & datastage. Which one would you choose and why?
What is the difference between account and directory options ?
How to clean the datastage repository?