Creating satellites
With the hubs established, the next step is to create satellites that store descriptive information related to each hub. Satellites provide context and depth to the keys stored in hubs, and they capture the descriptive attributes, changes over time, and the history of business concepts.
Your task will be to create these satellites.
Cet exercice fait partie du cours
Introduction to Data Modeling in Snowflake
Exercice interactif pratique
Essayez cet exercice en complétant cet exemple de code.
-- Create a new satellite
___ (
sat_employee_key NUMBER(10,0) AUTOINCREMENT PRIMARY KEY,
hub_employee_key NUMBER(10,0),
employee_name VARCHAR(255),
gender CHAR(1),
age NUMBER(3,0),
-- Add history tracking attributes
___ TIMESTAMP
___ VARCHAR(255),
-- Add a reference to foreign hub
FOREIGN KEY (___) REFERENCES ___(___)
);