How to remove slowing changing dimension

[muhammadraza]

Hi Guys,

I have a slowly changing dimension table as you can see, I want to remove this table want to make it a single table joined with sales table (so that I have a direct connection between employees and Sales table)

I have seen different techniques but I am not able to get how it will fit in my scenario.

PFA is my document and QVD files.

Regards,

Raza

[Anonymous]

Hi

Left join the SalesTerritoryHistory table & Territory table to Sales Table

now  u can see only 2 table

1.Employess 2.Sales

both the tables are linked with EmployeeID Field

[tyagishaila]

To connect employee and sales table there must be a common field to associate tables..

Rename EmployeeID in SalesTeritoryHistory Table

[marcus_malinow · Accepted solution]

Muhammad,

see the attached.

Looks like you were close, intervalmatch looks like the correct way to go here, but with a few changes from what you were doing.

Marcus