SQL Server Performance

Performance Tune for loading dimTable ???

Discussion in 'SQL Server 2005 Integration Services' started by khanhmy264, Mar 12, 2007.

  1. khanhmy264 New Member

    Hi all,

    "The Microsoft Data Warehouse Toolkit" by Joy Mundy, Warren Thornthwaite and Ralph Kimball
    notes that:

    "... the easiest way to compute the hashes is to use the Checksum transform available for download from www.sqlis.com ..."

    Please show me the way to use this component.
    And If you have better ideas to solve this problem, I greatly appreciate your help.


    best reguards,

    khanhmy
  2. satya Moderator

    Have you checked the sampleshttp://www.msftdwtoolkit.com/ToolsandUtilities/ToolandUtilities.htm on that book?>
    As this is quoted there:
    quote:As featured in The Microsoft Data Warehouse Toolkit by Joy Mundy and Warren Thornthwaite from the Kimbal Group. Have a look at the book samples especialy Sample package for custom SCD handling.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page