Duplicate Record in Datastage

I have one scenario below, how can we achieve.
City1,City2,Distance
==============
blr, pune,1000 km
pune, blr, 1000 km
As we have same data in 2 records but need to delete any one of the duplicate record.

Showing Answers 1 - 1 of 1 Answers

Ranajoy Gupta

  • Mar 20th, 2017
 

Use sort stage, put city1, city2 and distance as key columns, set allow duplicates as false.

  Was this answer useful?  Yes

Give your answer:

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

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions