Lookup on Multiple Tables in DI Studio
in [SAS]
|
From: Manik on 9 Oct 2009 05:27 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
|
Pages: 1 Prev: matrix mulitplication................... Next: Lookup on Multiple Tables in DI Studio... |