Sathish Kumar. Rajaram (4/15/2013)
I am a newbie currently trying handson on desinging SSIS and Star schema.
I have 2 tables Location (LocID, LocName) and Center (CenterID, CenterName, LocID). I have designed dimension tables as dimLocation (LocKey, LocID, LocName) and dmCenter (CenterKey, CenterID, CenterName, LocKey)
I have created a SSIS package to load dimLocation and dimCenter (without LocKey) tables. Now I wanted to load dimCenter table with LocKey lookup.
Please help, suggest how I can load my dimCenter table.
Use the Lookup transformation to get the LocKey from your DimLocation table and add it to your flow. Then write these values to your DimCenter table. Your SELECT in the lookup transformation would be:
SELECT LocKey, LockId FROM DimLocation;
Pretty straight forward.
What about the lookup transformation is causing you trouble?