Home Forums SQL Server 2005 SQL Server 2005 Integration Services what is the most efficient way to maintain a denormalized table? RE: what is the most efficient way to maintain a denormalized table?

  • March 15, 2010 at 3:49 pm

    #1134124

    To improve on your 15 hour process, I think we need to know a bit more about it. Can you give us an explanation of how you are 1) getting the data from your source tables; 2) staging the data; 3) tranformations to denormaize the data - when/where is that happening; 4) how are you inserting into destination table.

    Is this all SP driven or are you using SSIS or some other technology? Where is the bulk of the 15 hours spent?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden