Can a PIT table be created as a VIEW? Absolutely not! PIT and bridge tables are in essence JOIN INDEXES (a term borrowed from Teradata jargon) that enable equi-join performance gains when retrieving data from the underlying data vault structures. A well-constructed PIT table should include the business keys available in the hub table(s) so that a join to the hub is no longer necessary.
