Links model relationships between object of hubs.Only the (hash of this) unique key is stored in this object along with some technical logging columns. Hubs uniquely identify records (customers, products, ….) over systems throughout (and even outside of) the organisation.The three types of tables supporting the Data Vault layer, serve following purpose: Kimball-oriented layer, data/information marts, OLAP cubes). The goal of this layer Data Vault layer is to track every single change of attribute in your source systems and provide a consistent ‘base’ on which subsequent objects are built (e.g. It houses all data that your organisation has ever recorded and uniformly models it in three components: Hubs, Satellites and Links. In a Data Vault oriented Data Warehouse, the ‘Data Vault layer’ is the beating heart of your information.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |