Post reply

Populate Fact Tables incrementally SSIS 2005

  • June 16, 2011 at 3:17 am

    #237919

    Hi All,

    I have populated my dim tables from many base tables via joins in SCD. That part is working fine.

    But I dont know how to populate my fact table incrementally usind dim tables and base tables through joins.

    I searched on internet. It is showing me to use lookup transformations but at all the sites I failed to find any demo.

    Plz put fwd ur ideas.

    Thanks

    Ashish

  • June 16, 2011 at 3:43 am

    #1339525

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1126335-148-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 16, 2011 at 3:51 am

    #1339528

    I am not wasting any 1's time, just seeking help so as to solve my purpose.

  • June 24, 2011 at 2:13 am

    #1343515

    ashish.mehrotra (6/16/2011)

    I am not wasting any 1's time, just seeking help so as to solve my purpose.

    What if I spend some of my time researching this topic and typing in a reply in this thread, while it already might be solved in another thread?

    Definately a waste of my time...

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 4 posts - 1 through 3 (of 3 total)

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