One more thing......in the Microsoft Data Warehouse Toolkit, the actual use of the Lookup Transform is covered more in depth in

ETL Subsystem 13: Fact Table Builders

ETL Subsystem 14: Surrogate Key Pipeline

Technique #1: Using Cascading Lookups (via the lookup transform)

Technique #2: Using database joins