Forum Discussion
AlexisPREVOT
Resolver I
Resolver INo correspondence between table information
Hello, I am looking from a customer list to find the selling prices of the corresponding items. Here are my tables with their relationships to make it easier to understand: For each PR...
That's not a data model - they usually expect dimension tables and fact tables with 1:* relationships, ideally resulting in a snowflake layout. If you have multiple fact tables then they should be controlled via dimensions, and not by each other.
Can you decide which of your tables are dimensions and which are facts?
lbendlin
Super User
Super UserThat's not a data model - they usually expect dimension tables and fact tables with 1:* relationships, ideally resulting in a snowflake layout. If you have multiple fact tables then they should be controlled via dimensions, and not by each other.
Can you decide which of your tables are dimensions and which are facts?