Lately there were some interesting updates in the ever-existing ‘Kimball versus Inmon’ discussion. This this Bill Inmon wrote an article expressing his views on these things: http://www.b-eye-network.com/view/14115. A quote here sums it up for me: ‘If you want a tactical solution, then Kimball is the way to go. If you want a strategic solution, then Inmon is the way to go.’ All in all I think the Kimball approach is a good one if the goal is a stand...
Site visitors since October 2015
3NF architecture BIML Business data vault data modeling Data Vault Data Vault 2.0 Data Warehouse Driving Key DV2.0 EAI Enterprise architecture Error Bitmap Error handling ESB ETL ETL Automation ETL Framework ETL Generation hash key Hub Informatica inmon Kimball Link Link Satellite Logical Delete Metadata OWB PIT Powercenter PSA Ravos Referential Integrity Satellite SCD2 SQL Server SSIS Staging Area Staging Layer Time variance Training Virtual EDW Virtualisation XML
- Using (and moving to) raw data types for hash keys on
- Virtualising your Data Vault – regular and driving key Link Satellites on
- Schools of thought on implementing Multi-Active Satellites on
- Driving Keys and relationship history, one or more tables? on
- Data Vault versus the persistent Staging Area on