Scenario: Bank Accounts and Customers. One Account can have many customers and many customers can have one joint Account. so its Many to Many relationship.
Special Scenaio: Bank provide us daily snapshot of all thier dimensions and facts, every night thier ETL run, and newsnapshot is available, previous is gone.
I am using SCD Transformation to update the dimensions, Type 1 for all the columns.
Tables1: DimAccounts (AccountsID(PK))
Table3:DimBridge (AccountID (FK), CustomerID(FK), RelationShip (varchar10))
Question1: Are we supposed to treat bridge tables as Dimensions or Facts?
Question2:If it is to be treated as Dimension, How would I apply SCD Wizard to it, Since there are two business keys involved?
Question3: Do i need surrogate key in Bridge Table, like i have in other dimensions?
View Complete Post