In a typical Data Warehouse it is common to introduce additional descriptive information that is not provided by the operational systems feeding data into the Data Warehouse. However, the exact positioning and implementation of this reference data can cause confusion. Especially when applying this concept in the Integration Layer. Reference data is additional contextual or descriptive information that is not provided by the source system. Examples are descriptions for industry standard codes. This information can...
Site visitors since October 2015
3NF architecture BIML Business data vault CBIP 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 Hub Informatica inmon Kimball Link Link Satellite Logical Delete Metadata OBW OWB PIT Powercenter PSA Ravos Referential Integrity Satellite SCD2 SQL Server SSIS Staging Area Staging Layer Time variance Virtual EDW Virtualisation XML
Search this site
Upcoming Training and Speaking Events
3-day Data Vault Implementation and Automation training in (northern) Germany - October 2018. Register here