Data Warehousing - Glossary

PIT: Point In Time.

You can have several different PIT report. Stock, status, state of an order for one defined date…

Data Warehouse / Data Marts

• data warehouses : e.g., comprehensive, enterprise-wide, etc.
• data marts : e.g., subject-or application-specific

Source dependent/independent

• SDE : source dependent executions
• SIL : source independent loads

EDW

• enterprise data warehouse

The EDW should be structured based on the subject areas in your Enterprise Data Model.