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 two 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