1)How to Duplicate Records Delete in Sequential file?
Answer Posted / subhash
small correction to Vinod answer,
If we use UNIQ, it will remove duplicate if they are
consecutive only..
so, better to use
sort -u
or
sort file_name | uniq
Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Differentiate between operational datastage (ods) and data warehouse?
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 the difference between datastage and datastage tx?
What are the types of hashed files in data stage
What are the different kinds of views available in a datastage director?
how to add a new records into source?
Which warehouse using in your datawarehouse
What are the different plug-ins stages used in your projects?
How do y read Sequential file from job control?
Can you explain kafka connector?
Can you explain how could anyone drop the index before loading the data in target in datastage?
What are the processing stages?
What are constraints and derivations?
Highlight the main features of datastage?
What are stage variables and constants?