Forum Discussion

AlexisPREVOT's avatar
AlexisPREVOT
Resolver I
4 years ago
Solved

No 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...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    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?

AlexisPREVOT's avatar
AlexisPREVOT
Resolver I
4 years ago

Hi Anonymous and lbendlin ,

 

Thank you for your answers.

 

I'm going to try to do the star schema but I feel like I only have fact tables so I'm going to have to try transforming them to make it work.

Thank you again for your help