DW
- Depository: all job donw after transition finished
- Store: no update/delete
- Reporting: Multi Dimentional
- Analysis: With historical records
- BI
ETL
Design A DW:
- whakt kindss of reports
- how often need to be generated
- add data or part
- can I use same structure