I have a datamodel which is based on star schema. In the Fact table there are two fields named: Office ID and Pickup date. Now I have to add another table to the data model which contains Office ID and Pickup date field. The problem here is that in Fact Table there are some pickup dates where not all offices are present . But in new table all the dates have all offices values in them. So when I am trying to directly associate them , either dates go missing or offices have invalid values.
Please someone suggest a workaround for this requirement.