Fig. 2 shows a very simple example data flow chart showing how to populate a lookup cache; this would be the example T-SQL code: SELECT ContactID, EmailAddress FROM Person.contact ...