Post reply

Load dim Table using Lookup

  • April 15, 2013 at 5:00 am

    #276495

    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

  • April 16, 2013 at 6:09 am

    #1606779

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply