Questions
The following are additional questions from the Asking in the right direction section:
- General questions: Your modern data warehouse may need to hold data for a longer period. Do you need different access tiers (hot, cool, or archive)? Is older data not accessed that often? How do you need to design the access rights to the data? Are there only automatic processes, or will users want to access data themselves? Do you need to establish replication for reliability, and to what extent?
- Data loading: Are you planning for a new ETL/ELT tool? Do you want to run that in the cloud or on-premises? What are your expectations for the availability of connectors? What are your expectations for usability, or do you want to code your data transport layer? What language do you prefer for this? What will the volume of the data be that is to be transported? Do you need parallel processes? Do you expect scalability?
- Data transformation: Do you want to perform data transformation...