Hi,
I have a process that runs at multiple different times of the day.
The process runs at 12pm, 2pm and 3pm daily.
The input files are incremented each time the process runs. Eg: 2pm file contains 2pm and 12pm wire transactions, 3pm file contains 12pm, 2pm and 3pm wire transactions,
I need to remove transactions that were previously processed.
So I need to compare collections are remove duplicate rows.
Suggestions welcome.