Post reply

Incremental process in SSAS

  • September 1, 2009 at 5:18 am

    #385292

    D/A,

    Pls help on how to incremental process in SSAS.

    Eg

    Fact Table : FCT_CS (CS_SKEY,Date_SKEY)

    DIM Table : DIM_CS (CS_SKEY,name) , DIM_TIME (date_SKEY,yr,qtr,mth,dy)

    FCT_CS and DIM_CS - new data will be appended on a daily basis

    DIM_TIME will be constant

    Currently am using Process full. Pls guide how to perform process incremental.

    Thanks....Gugan

  • September 16, 2009 at 6:09 pm

    #1054770

    Create a new SSIS package using BIDS, use Analysis Services Processing Task. Set the properties, and choose Incremental Update in Processing Setting option

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

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