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 areas of application?
How one source columns or rows to be loaded in to two different tables?
What is aggtorec restructure operator?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What are the different layers in the information server architecture?
Can you define merge?
Can you explain engine tier in information server?
What are the main features of datastage?
What are stage variables?
What are the types of containers in datastage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What is the difference between server job and parallel jobs?
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)
Notification Activity
What are stage variables and constants?