Notifications
Clear all

Why you should consider PIT tables


Posts: 743
Topic starter
(@patrick-cuba)
Honorable Member
Joined: 2 years ago

Worth a read (link below), I recently saw an implementation of a "PIT" as a view between a hub and a satellite. What join performance do you get from this? NONE.

Section 6.1 (page 151) of Dan's book discusses PIT tables, that's right tables as an efficient way to get data out of data vault. The blog post presents other reasons and a certain platform that uses this structure very efficiently and why it works so well.

https://patrickcuba.medium.com/why-equijoins-matter-8241b01d251e

 

Reply
1 Reply