SQL Server Performance Forum – Threads Archive
Performance Tune for loading dimTable ???
Hi all, "The Microsoft Data Warehouse Toolkit" by Joy Mundy, Warren Thornthwaite and Ralph Kimballnotes 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
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.
]]>