Agile development means being able to accomplish goals in short time frames. In order to do this with a data warehouse, there are two issues. First is being able to deliver results to the business quickly. Second is having an architecture to execute shorter deliveries. The pattern of Data Vault design provides the architecture. There are some bumps in the road for developers if they are not familiar with this design. This is no different than the change of mind going from database normalization to dimensional modeling. The dimensional model can still be used as an information mart on top of the data vault. The real funs begins when metadata (data about data) is used to automate some processes. The metadata can use the repeatable patterns for structured ETL or ELT whether using T-SQL or SSIS. The end result will include documentation for management from this metadata.
Watch the session recording from PASS Summit 2020. For updates on the future of PASS, SQLSaturdays and PASS Summit opt in here: [ Ссылка ]
