I have two data flows from two separate flat files. They may contain matching IDs (account number), in this case specific data from each flow should be used to create one row. When there is no match, the rows would stand on their own. At the end of the flow,
I need both flows combined into one flow, with one record for each key record (account number).
If I were able to use a look-up, I could easily union the no-match data flow back into the match data flow and have the desired result. I cannot use a look-up, since the source is flat files, but this is exactly the functionality I am trying to achieve.
Solutions I want to avoid: staging tables, and cache transformations.
Any ideas are appreciated.
View Complete Post