Link
Defines a foreign key relationship between two database tables, establishing referential integrity constraints that are essential for dimensional modeling in OLAP systems. Links connect fact tables to dimension tables, enabling proper join relationships for star and snowflake schema implementations.
Extends
Attributes
| Name | Id | Type | Lower | Upper |
|---|
References
| Name | Type | Lower | Upper | Containment |
|---|---|---|---|---|
| primaryKey | Column🔗 | 1 | 1 | false |
| Reference to the primary key column in the target dimension table. This column serves as the unique identifier that foreign key columns reference to establish table relationships in the dimensional model. | ||||
| foreignKey | Column🔗 | 1 | 1 | false |
| Reference to the foreign key column in the source table (typically a fact table) that points to the primary key in the target dimension table. This column contains dimension key values that enable joins between fact and dimension tables. | ||||