GeekInterview.com
Series: Subject: Topic:
Question: 1 of 44

Splitting and merging of file using sort

Hi,I have a file which contains 3 types of transactions with account number,transaction type and transaction creation date.The transaction types are 35,39 and 41.The file has duplicate records for all transactions(ie 2 records for each account number for each transaction).Now I need to remove the duplicate for the 39 type transaction alone and keep the remaining.That is only for the transaction type 39 the duplicate record(record with old transaction date) need to be removed and for the remaining transactions the duplicates need to be there.How to achieve this in a single sort step?
Asked by: Interview Candidate | Asked on: Oct 19th, 2011
Showing Answers 1 - 1 of 1 Answers
ramu

Answered On : Jun 27th, 2012

Use ksds files it will wont allow duplicates in this keys are used to eliminates the duplicates

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.