I’m new in data warehouse modeling, and I’m working on analyzing sales data. I have three tables: store, product, and client. Each store and client has an address, and I have a geographic dimension where I created a unique ID for each address (in that dimension I have latitude, longitude, number_street, street, postal_code, city and country.
So I replace the adress of store and client for a reference to adress_id.
However, I’m not sure how to incorporate the geographic dimension into my analysis because I have two addresses for each entity. I mean geographic dimension must to connect directly to my fact table or to each dimension?