Ordered Loading of Databases Tables Using SSIS

  • Joe Ferry

    SSC Enthusiast

    Points: 113

    Comments posted to this topic are about the item Ordered Loading of Databases Tables Using SSIS

  • sneumersky

    SSCertifiable

    Points: 7667

    Good article regarding loading of OLTP data and covering lots of ground. In a dimensional data warehouse the order of loading would be:

    1. Subdimensions

    2. Dimensions

    3. Bridge tables (Fact-to-Dimension and Dimension-to-Dimension)

    4. Fact tables

    5. Hierarchy mappings

    6. Aggregate (shrunken) dimensions

    7. Aggregate fact tables

    For more info, check out the Data Warehouse ETL Toolkit by Joe Caserta and Ralph Kimball. Good work!

  • ccmalls16

    Grasshopper

    Points: 13

    Wonderful.

    Share a website with you ,

    ( http://www.ccmalls.net/ )

    Believe you will love it.

    We accept any form of payment.

  • Joe Ferry

    SSC Enthusiast

    Points: 113

    Thanks for the feedback. This is my first article, and getting a positive comment is very encouraging!

  • ccmalls21

    SSC Rookie

    Points: 38

    Wonderful.

    Share a website with you ,

    ( http://www.ccmalls.net/ )

    Believe you will love it.

    We accept any form of payment.

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

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