Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.