From: Manik on
Hi,

Requirement is to do multiple lookups on different tables. e.g. to get
the Calendar_SK (surrogate key), Customer_SK to be populated in the
fact table. In such a case should you use to instances of the lookup
transformation or is it advisable to use one lookup transformation and
connect both the lookup tables to that transformation?

Regards,
Manik