DSXchange

Hi Everyone,

Greetings!

we are have two files file1 and file2.
Our requirement is to compare these two files and give the below outputs:

If the records match, give the output from file2.
If the records do not match,give the output from file1.

Could you please suggest a way to achieve this.

Do you need to handle records missing from one file or the other? Meaning they exist in File1 but not File2 or vice versa...

Thank you for immediate reply. Please assume that file1 is source file and file2 is the reference file.the scenario is such that the record may be present in source and reference files as well.this is not the case of missing files.if the record is present in reference file,irrespective of source file, the record should be loaded from reference file.if the record is not available in reference file then only we have to load the file from source.

Full outer join in Join stage, filter using IsNotNull() function.

Yes, that would be the full service solution. That would allow you to check for differences and/or 'missing' records from either side via null checks as Ray notes.