Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Load dim Table using Lookup Expand / Collapse
Author
Message
Posted Monday, April 15, 2013 5:00 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, September 15, 2014 11:26 PM
Points: 183, Visits: 53
Hi,

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.

Thanks
Sathish


S A T ...
Sathish's Blog
Post #1442252
Posted Tuesday, April 16, 2013 6:09 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, October 27, 2014 2:55 PM
Points: 1,197, Visits: 1,244
Sathish Kumar. Rajaram (4/15/2013)
Hi,

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?

Rob
Post #1442700
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse