I have a flat file (source) with data that looks like this :
1,2,3
4,5,6
And a second flat file (source) that look like this:
1,2,3
I want result (target) to be a flat file that looks like this:
4,5,6
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.