|
Describe the foreign key columns in fact table and dimension table.The primary keys of entity tables are the foreign keys of dimension tables.The Primary keys of fact dimensional table are the foreign keys of fact tables.
Describe the foreign key columns in fact table and dimension table.A foreign key of a fact table references other dimension tables. On the other hand, dimension table being a referenced table itself, having foreign key reference from one or more tables.
|
