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
How can you write parallel routines in datastage PX?
What is usage analysis in datastage?
State the difference between an operational datastage and a data warehouse?
Can you implement SCD2 using join, transformer and funnel stage?
If you want to use the same piece of code in different jobs, how will you achieve it?
What are the functionalities of link partitioner and link collector?
What are iconv and oconv?
sed,awk,head
What is the difference between datastage and informatica?
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)
What is orabulk stage?
What is the difference between in process and inter process?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Explain Quality stage?
Can you filter data in hashed file?