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.
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.
