Datenintegrität (EN)

Data Integrity in Data Warehousing

flowchart TD     A[Source Systems] --> B[ETL Process]     B --> C{Validation Rules}     C --> D[Data Cleansing]     D --> E[Transformation Logic]     E --> F[Constraints]     F --> G[Primary Keys]     G --> H[Foreign Keys]     H --> I[Data Warehouse]     I --> J[Analyses & Reports]          subgraph Data Integrity         C         D         E         F         G         H     end 

In Context

• Typically used together with data quality management, data governance, and master data management
• Related to: data consistency, data validation, referential integrity
• Example use case: Ensuring that order numbers in transaction data actually exist in the product master data