data model relationships

[surajap123]

Hi Experts,

Our Fact table linked to multiple dimension tables. Few dimension tables are futher linked to another dimension table.

To investigate the issues in the data model i want to find the following-

1. How to find whether linking between fact and dimension table is one-to-one or one-many or many-to-many.

2. How to find if there is granularity issue between fact and dimension table?

Please let me know ways to investigate this.

Thanks.

[Gysbert_Wassenaar · Accepted solution]

You can create tables with a field from one table and a count of a field from another associated table. If you find counts larger than one then you have a one-to-many relationship. If you then do the same the other way around you can check if the one-to-many is actually a many-to-many relationship.