I have a scenario for duplicate removal on field by field basis as mentioned below which I need to implement in Informatica or Oracle. Please let me know how to do it.

![](https://i.stack.imgur.com/gs9hQ.jpg)