Retreive reference records from lookup

hemaarvind1 · Post by **hemaarvind1** » Thu Oct 18, 2012 9:26 am

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.

chulett · Post by **chulett** » Thu Oct 18, 2012 9:28 am

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

hemaarvind1 · Post by **hemaarvind1** » Thu Oct 18, 2012 12:01 pm

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.

ray.wurlod · Post by **ray.wurlod** » Thu Oct 18, 2012 2:03 pm

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

chulett · Post by **chulett** » Fri Oct 19, 2012 6:51 am

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.