Home Forums Data Warehousing Strategies and Ideas Using Bridge tables for 1 to Many Relationships. Primary and Foreign Key Creation RE: Using Bridge tables for 1 to Many Relationships. Primary and Foreign Key Creation

  • Thank you.....

    In the end I went with:

    Fact table (FK) to Group Table (PK) to bridge table (FK using the parent ID) to Dimension table (PK)

    I just used an example (Healthcare) rather than using my actual business area.

    For the parent key, I just set it against the most recent data item for this specific schema.

    I do have a seperate dimension for my person details which is a one to one relationship.

    Thats really useful information. That you so much. I have read that many people dont bother using foreign keys for their schemas and that seems like an easy way to do it (But a wrong way)

    Thanks again

    Debbie