SCD2 Implementation with 5 Master data time dependent tables
Hi
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.
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.
