Creating links
The final piece in the data vault model for HR is the creation of Links. Links represent relationships between hubs or capture transactions and interactions involving multiple hubs.
Your task is creating a link entity representing the relationship or interaction between the employee, training, and department hubs.
Bu egzersiz
Introduction to Data Modeling in Snowflake
kursunun bir parçasıdırUygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Create a new entity
___ link_all (
-- Add a unique identifier to the link
link_key NUMBER(10,0) ___,
-- Add history tracking attributes
load_date ___,
record_source ___
);