• That really depends on your requirements and how that data is stored/represented on the front end. For example if you normalize the address information and link it with a fact table if that address changes it will change all the historical data, that may or may not be desired in a datawarehouse

    The Address Is linked to a booking so it's added everytime a booking is made.

    It just so happens some client make multiple bookings to the same destination. So that wouldn't be an issue.

    Thanks