Slowly Changing Dimension Question

[#1]

i have seen examples of how to do a SCD,

but how about if i have a third table which i have to join, how can i Implement this into my Script? What i need is basically the ProjectHdrName for every employee, and after that create the SCD.

have checked the web, but its hard to find any solutions.

Load    ProjectHdr

          ID,   

          ProjectHdrName

          from ProjectHdr.qvd

  Load    TimeReport

          DateKey

          from TimeReport.qvd

  Load    Employee

          EmployeeID,

          Department,

          Name,

          StartDate,

          EndDate

          from excel file

[#2]

Hi,

Using of intervalmatch() you can develop the SCD.

SRC:

  Load    TimeReport

          DateKey

          from TimeReport.qvd

Emp:

Load    Employee

            EmployeeID,

          Department,

          Name,

          StartDate,

          EndDate

from excel file.

SCD:

Intrvalmatch(Datekey) load StartDate,EndDate resident Emp;

[#3]

Hi Rakesh, thx for answer.

After i apply the intervalmatch code, i cant load my Employee table, let me upload my script and u will see