how exclude matching rows in 2 flat files using informatica? i have flat file (source) data looks (normally lot more data): 1,2,3 4,5,6 and second flat file (source) this: 1,2,3 i want result (target) flat file looks this: 4,5,6 i know in sql there exclude (opposite of intersect) job. doing flat files , informatica. i pretty new informatica. have been doing month. might rather obvious. if tell me tranformations use great. you can use union transformation union result sets both files. give following result set . col1, col2, col3 ----------------- 1,2,3 4,5,6 1,2,3 after use aggregator transformation , select these ports (and ever want group consider them duplicate) , count in aggregator transformation. after aggregator (new column count => total_count) ---------------------------------------------------- col1, col2, col3,total_count ----------------------------- 1,2,3,2 4,5,6,1 the next step simple, pass them through filter transformation , us...