Here I was believing in Kimball! To prove or disprove my guru's theory I went and looked at a client database that has been in operation for about a year....

Quoting "The Microsoft Data Warehouse Toolkit" by Ross and Kimball pg 245: "...This is a common technique for high performance dimension change management. Compute the hashes and store them in...

I dont agree with this. An index is only useful for retrieving...

Wrapping hashbytes with checksum is not bad as long as you include all columns in your join as indicated and create the index including all columns required for the join....

In reply to : fnHashCalc(field1, Field2) AS Meta_Hash

Its not the most elegant solution but checksum(fnHash(field1), fnHash(field2)) as Meta_hash will do what you looking for...

Hi

Iv'e been developing a DWH for about three years and starting using this technique about a year ago. I started off by trying a checksum but that was way off...