Forum Discussion
Solved
Hashed Primary Keys for Idempotence
One of the major trends in data warehousing right now is the avoidance of integer surrogate keys because the eliminate idempotence (i.e. you have to reload the tables to regeneate them). As an alter...
You may want to read a couple of the articles that discuss Vertipaq compression techniques and their performance, like this one
Inside VertiPaq - Compress for success - Data Mozart (data-mozart.com)
What a helpful article, thanks! I spoke to a friend who shared that he's tried this and using hashed keys instead of integer keys doesn't make a huge difference. This seems to fit with what the article describes. Thanks!