Please enable JavaScript.
Coggle requires JavaScript to display documents.
NSW CMS DWH Design - Coggle Diagram
NSW CMS DWH Design
Environment design
Environment ownership
Hosted in
Cloud
On Prem
Different environments needed
Dev
Testing
Production
Data sources
Identify all the data sources
Identify the data structures under each data sources
OLAP Requirements - Clearly identify whether this is needed or not
Data Quality Requirement
No explicit requirement for cleansing
However L & G would like to understand where data is changed
differentiate between data that get changed and not
Data modeling
Design
Documentation
Tools and technologies to be used
Should we be aligned with DAC existing Technologies or do we have a freehand in selecting the tools and technologies to be used
Security
Data on rest and on motion needs to be secured