Hi This is Vijay,
How can your remove the duplicates in sequential File?
Answer Posted / chowdary
in sequntial file options filter--> sort | uniq -d
this will give best performence to remove duplicates.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the different options associated with dsjob command?
What are the various kinds of the hash file?
What is the sortmerge collector?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
What are the different plug-ins stages used in your projects?
How many types of views are there in a datastage director?
In Datastage, how you can fix the truncated data error?
Define orabulk and bcp stages?
what is use of SDR function?
What is the importance of the exception activity in datastage?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What is the difference between Datastage 7.5 and 7.0?
What are stage variables, derivations and constants?
What is process model?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do