Exercise

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.

Instructions 1/3

undefined XP

1

2

3

Create a link_all entity, with an attribute link_key as an autoincrement number to be the entity's unique identifier.
Include the attributes load_date, with datatype TIMESTAMP, and record_source as characters of 255 long, to track history of the records.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions 1/3

Exercise