I have a flat file (source) with data that looks like this :
And a second flat file (source) that look like this:
I want result (target) to be a flat file that looks like this:
I know in SQL there is an EXCLUDE (opposite of INTERSECT) that would do the job. But I am doing this all with flat files and Informatica.
If anyone can tell what transformations should I use, that would be a great help.