link table

[prabhas277]

Hi experts,

If we are using link table then it will be belongs to starschema or snowflex?

[Siva_Sankar]

Prabhas,

There will be only one fact table in the Star schema, but sometimes if you have to use more than one.

In that case then use the link tables in between them which is used as the reference table. You can use link table in both star as well as snow flake.

It is just to avoid synthetic key.

[Siva_Sankar]