Clear all

Why you should consider PIT tables

Posts: 743
Topic starter
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.


1 Reply