I find myself repeating lookups when I have insert and update paths. In my data flows I use a Lookup component to check if the row already exists in the destination table. I insert the row in the No Match output path and update in the Match path.
I often have to do the same for the insert and update paths. I always have to do them in the insert and might have to do them for the updates. In the update path I use conditional splits to check if values have changed - if they have - then I lookup
for example a supplier data warehouse key. I could place it before the lookup that check if the row exists but it would be a waste - because often the supplier did not change - some other value did.
So I end up with 2 copies of my lookups I have to maintain :(
Hope someone can help me out.
View Complete Post