Clear all

Are PIT and BRIDGE tables source system specific?

Posts: 145
Topic starter
Estimable Member
Joined: 1 year ago

My current vault exists which is taking data for a Loan system (say System A) and reports are produced out of Information mart. For performance temporal PIT and BRIDGE tables are developed in the vault. 

Now we have to integrate other loan  systems in the vault and there is also a plan to replace system A with a new age loan system. In such cases should the existing temporal PIT tables be extended to the new systems and COALESCE should be used in the Info mart DIMs or new temporal PIT & BRIDGE  tables are suggested for new systems and Information mart will have UNION in DIM views and FACT views?

7 Replies