SCD2 Implementation with 5 Master data time dependent tables

[vishnumusani]

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

I am able to establish a bridge table using 2 master tables along with a transaction,but when i am trying the same approach to add another dimension table to script it is causing issues.

Could you please let me know what could be the approach to build the model by considering the time dependencies.

Regards,

Vishnu.

[vishnumusani]

HI Henric,

If i try to create a separate bridge table for each combination i am ending up with a circular reference with respect to employee information as it consists i both the bridge tables.

Regards,

Vishnu.

[vishnumusani]

Henric,

Here is the circular reference what i am getting.

[vishnumusani]

Hi Dathu,

I am placing the common join keys in transaction table after joining transaction table with bridge tables and deleting individual keys from Transaction table in order to avoid multiple joins.

Regards,

Vishnu.