When it comes to record condensing, DISTINCT just doesn’t cut it. I’ve been meaning to post about this for ages as the earliest templates (as also posted on this site) were not flexible enough to work in all cases (which is what we strive for). Record condensing Record condensing is making sure that the data delta (differential) you process is a true delta for the specific scope. It’s about making sure no redundant records are processed into...
3NF architecture BIML Business data vault data modeling Data Vault Data Vault 2.0 Data Warehouse Driving Key DV2.0 Enterprise architecture Error Bitmap Error handling ETL ETL Automation ETL Framework ETL Generation hash key Hub inmon Kimball Link Link Satellite Logical Delete Metadata OWB PIT Powercenter PSA Ravos Referential Integrity Satellite SCD2 SQL SQL Server SSIS Staging Area Staging Layer TEAM Time variance Training VEDW Virtual EDW Virtualisation XML
Search this site
Upcoming Training and Speaking Events
3-day Virtual DWH / Data Vault Implementation Training - Utrecht, The Netherlands - June 24-26 2019. Register here