not knowing your data model it isn't easy to answer. But a first guess is trying to "concatenate load" your hist. teams to your team-table. This will append your rows of the hist. team to the existing teams. It will work fine, if the source-fields are (almost) the same and the concatenate load statement follows dierctly after the load statement of the teams. Since you still have a link to the date field of your date-dimension try to use a second date-dim, let's call it teamdate. And teams having no teamdate are actual teams. Is this a valid option?