First published on MSDN on Nov 22, 2008
From the Lookup presentation I put together for the MS BI conference in October, here is a series of posts which describe different patterns for using the Lookup transform.
- http://blogs.msdn.com/mattm/archive/2008/11/22/lookup-pattern-key-generation.aspx
- http://blogs.msdn.com/mattm/archive/2008/11/22/lookup-pattern-upsert.aspx
- http://blogs.msdn.com/mattm/archive/2008/11/22/lookup-pattern-cascading.aspx
- http://blogs.msdn.com/mattm/archive/2008/11/23/lookup-pattern-case-insensitive.aspx
- http://blogs.msdn.com/mattm/archive/2008/11/23/lookup-pattern-incremental-persistent-cache-updates.aspx
- http://blogs.msdn.com/mattm/archive/2008/11/25/lookup-pattern-range-lookups.aspx
Each pattern will contain a diagram with Upstream and Downstream images.
These represent any collection of source / transform / destination components that could appear before/after the Lookup section described in the pattern.
Updated Mar 25, 2019
Version 2.0