Another excellent overview of the de-normalization in Data Vault Raw Staging by Michael Olschimke, CEO of Scalefree. De-normalization is typically useful in loading LINK SATellites and Non-Historized (Non-Delta Driven) LINKS. Michael also covers challenges with de-normalization when using CDC.