Tagged: OBW

Mapping generation for Data Vault demo: part 5 (hubs and satellites) 0

Mapping generation for Data Vault demo: part 5 (hubs and satellites)

After the successful creation of a history layer, it is time to focus on the core parts of the datawarehouse: the Data Vault. In this example a ‘raw’ Data Vault is created: no changes or transformations are done here. The first script in this layer creates the Hubs and the corresponding Satellite. Currently this is done based on the history layer, which is probably not the best approach. It would be better to have the...