Tabular-Surrogate Key的维度建模 [英] Dimensional modelling for Tabular-Surrogate Key

问题描述

您好

我试图了解代理键如何在事实表格中起作用事务没有这个。

I am trying to get my head around how will a surrogate key work in a fact table if the source transactions do not have this .

我知道我们可以设置这个维度唯一的主键，但是与事实表的关系将是外键或自然键。有一个与之相关的代理键吗？

I do understand that we can set this a primary key unique to the dimension, however the relationship to the fact table will be the foreign key or natural key which would have a surrogate key to relate to ?

有关创建此内容的一些指导意见将会受到赞赏 

Some guidance around creating this would be appreciated 

谢谢

推荐答案

嗨VilenVmo，

Hi VilenVmo,

根据您的描述，我知道您的意思是在维度表和事实表之间创建关系。基于此，您可以按照此提示开始您的任务。

Per your description, I know that you mean to create relationship between dimension table and fact table. Based on this, you could follow this tip to start your task.

创建关系

最好的问候，

将

这篇关于Tabular-Surrogate Key的维度建模的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！