> Hi,
>
> I am in the middle of creating a data warehouse and wanted to add some
> FK constraints.
> However, I've found that when creating them via the 'relationships'
> tab, something strange occurs!
> I have a FACT table which references PKs in my Dimension tables, hence
> my FKs.
> Though, when I create the FKs in my FACT table, an identical entry is
> automatically created in the dimension. My issue lies in truncating
> the DIM (after truncating the FACT of course), even though my Dimension
>
> isn't referenced by anything else.
>
>
> Should I be created the FKs differently?
> Can anyone suggest how to overcome this problem.
>
>
> Thanks in advance,
>
>