A dimension table needs a generalized key as the primary key data; this becomes the foreign key in the fact table.

维度表需要作为主键数据的通用键；这将作为事实表的外键。

youdao

Query performance can be improved by leveraging like data types (i.e. INT32 to INT32) when joining foreign keys in a fact table to primary keys in a dimension table.

通过在将 fact 表中的外键与 dimension 表中的主键进行连接时采用 like 数据类型（例如 INT32 to INT32），可提高查询性能。

youdao