SCD2 Implementation with 5 Master data time dependent tables

vishnumusani — Thu, 15 Oct 2015 08:12:37 GMT

I do have total 5 Master data tables and all those are time dependent. In Employee table i have all other MD tables unique key and also all unique keys of these are available in my Transaction table.

MD Tables: Employee, Organization, Person, Position, Job.

Transaction : One Table

Forgot to mention that my Employee table is interdependent with remaining dimension tables. So I followed below approach to build model

1) Join Employee & Organization Table using "Organization Unit with inner join and stored that data into a temporary table

2) used Range max & Range Min along with Where clause to identify overlapping dates for Both Employee & Organization

3) Tried to integrate intermediate table with transactions table as per SCD process.

followed similar process with other master data but i am not getting desired results. Attached is the sample data and models that i am able to build which are not giving desired results.

Could you please let me know where exactly i am going wrong.

Regards,

Vishnu.

topic SCD2 Implementation with 5 Master data time dependent tables in QlikView

SCD2 Implementation with 5 Master data time dependent tables