Data Tables(Fact Tables)
- Purpose: Store detailed, raw data.
- Structure: Multiple columns (attributes) and rows (records).
- Example: A table with order details (order ID, customer ID, product ID, quantity, price, date).
Lookup Tables(Dimension Tables)
- Purpose: Map or reference specific values to ensure consistency.
- Structure: Key-value pairs (usually fewer columns).
- Example: A table translating product IDs to product names (product ID, product name).
Key Differences
| Aspect | Data Tables | Lookup Tables |
|---|---|---|
| Use | Store raw data for analysis | Reference and standardize values |
| Data | Detailed and comprehensive | Simplified and static |
| Example | Order details | Product names |
In summary:
- Data tables contain all the detailed information you need for analysis.
- Lookup tables help you translate or look up specific values to keep your data consistent.