search

MicrosoftLearning / mslearn-fabric

This repository hosts content related to Microsoft Fabric content on Microsoft Learn.
https://microsoftlearning.github.io/mslearn-fabric/
MIT License
147 stars 108 forks source link

Need more guidance on which fields to use when creating relationships between tables #117

Closed weslbo closed 1 week ago

weslbo commented 3 months ago

14-create-a-star-schema-model Step: Create relationships between tables

It is not mentioned which fields should be selected for creating the relationships

"Create relationships to the Trip fact table from the Geography and Weather dimensions, repeating the step above. Also ensure these relationships are One to many, with one occurance of the key in the dimension table, and many in the fact table."

For Geography table: is it DropoffGeographyId or PickupGeographyId? From Weather table: is it DateID?

weslbo commented 3 months ago

also need more guidance on One to Many.... (as in the picture it is opposite between trip and weather table)

AngieRudduck commented 1 week ago

Resolved. https://microsoftlearning.github.io/mslearn-fabric/Instructions/Labs/14-create-a-star-schema-model.html#create-relationships-between-tables