I have not found a reason WHY, but the suggestion is generally to use DISTINCT with your SELECT query.
It would be good if you could please post either a complete screenshot of those six records or a text export of them. I don't believe that they are really duplicates, I haven't seen such things happening before.
It is there. I am sorry because I can not share the data as it will be a issue from my company. But if you will query this view for any session which is loading data in multiple tables then you will find the duplicate rows which are exactly same.
I am not sure why informatica is showing us the duplicate rows if they can put a DISTINCT in its query to skip those.
Yes, I can do that but still I am not sure why informatica is showing the duplicate rows if they can put a DISTINCT in its query to skip those.