Upsert data from multiple files to single file
Posted: Fri Mar 23, 2007 4:33 am
Hello folks
I have 2 files , each row is defined by 3 Key Columns . Apart from that i have 2 Non Key columns as well . Some keys are common on both the files , preference to the output then goes to data from first file .
If the records are unique on either files, they qualify for output automatically .
One way for doing this is a FullOuter followed bu filter for Nulls and Commons .This requires a couple of transformers .
Was wondering if there was a better way of going round it ?
I have 2 files , each row is defined by 3 Key Columns . Apart from that i have 2 Non Key columns as well . Some keys are common on both the files , preference to the output then goes to data from first file .
If the records are unique on either files, they qualify for output automatically .
One way for doing this is a FullOuter followed bu filter for Nulls and Commons .This requires a couple of transformers .
Was wondering if there was a better way of going round it ?