Koen Verbeeck (5/6/2014)
skaggs.andrew (5/6/2014)
Thanks for the response DouglasH. The lookup is the destination table for this workflow. Not really sure how to redesign this mapping to use multiple lookups to achieve the same result. It seems kinda weird to me that this is failing because the records that are being cached are not large in width and there are roughly 15 columns that I am caching. This just seems really odd.Any other suggestions?
Why are you caching 15 columns? Do you need them all to do the lookup?
I am caching these 15 columns because if there is a match (joining on 3 columns) I want these records to continue to a conditional split transformation. In there I will check each column to see if the column value from the source matches the column value from the target. This is where I can determine what records need updated in the target table.
In the caching I am also already using a where clause to reduce any unnecessary records. The lookup only contains the records/columns that I need.