Recently at the Worldwide Data Vault Conference in Vermont USA (WWDVC) I had many conversations about the Persistent Staging Area (PSA) concept, also known as Historical Staging Area. I have been using this idea for years and really can’t do without it. I would even go as far as saying you really want a PSA in your architecture. However there is a common opinion that having a PSA isn’t the best idea as it introduces a ‘2nd...
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