Data Vault 2.0. When to Implement, Analysis of the Main Problems of Methodology Application When Building DWH on Greenplum

DWH = Data Vault on Greenplum architecture is now mainstream and is considered a 100% working option for building data warehouses. However, when applying this approach head-on, there are a lot of corner cases that can lead to both system performance sagging and high TTM of tasks for creating dozens of unnecessary objects.

During the talk, we will analyse the "prod" version of DV Ecom.tech concept using the example of abstract sales modelling with an explanation of all decisions made and possible alternatives.