From: Manik on 9 Oct 2009 05:29 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
|
Pages: 1 Prev: Lookup on Multiple Tables in DI Studio Next: DDE Word, AppMinimize |