A transaction table stores one row per second, but all required analysis is daily by product. The model is too large. Which change best reduces its size while preserving requirements?

1. Change every numeric column to text
2. Create more bidirectional relationships
3. Hide the second-level timestamp
4. Aggregate to day and product before loading