Post reply

SSIS 2012 Parallel Execution

  • November 15, 2015 at 10:05 am

    #322312

    Dear all,

    I am new to SSIS and ETL in general. If you could kindly shed some light on the following topic that I have:

    What's the order of the tables in which data should be loaded into DW db shown in the below link in order to make use of SSIS parallel execution ?

    Thanks,

    Ionut

  • November 15, 2015 at 2:46 pm

    #1839860

    Work from the outside in, loading the tables with no dependencies first. The fact table comes last.

    Why? Because the tables closer to the fact tables depend on the existence of rows in the outer dim tables ... so you need to create those first.

    Regarding parallelism ... it should follow from the above reasoning. Please post what you think the answer is & someone here will tell you whether you're right. It's all about not trying to load a child table before (or while) its master rows are loaded.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • November 18, 2015 at 1:30 pm

    #1840835

    Thank you so much for the reply. I had an idea that fact tables should be loaded last, I didn't know how to proceed with the dimension tables in snowflake schemas. Indeed, parallel execution in ssis has to follow the same logic.

    Ionut

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

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