Notifications

Clear all

What are PIT tables? Poll is created on Jan 22, 2021

They are special tables constructed to provide index-on-index joins between a business entity (or relationship) and its satellites

They are views constructed to simplify the joins needed to to perform between satellite tables

They are deep chasms of of historical data that goes as far back as the data is available

They are constructed only when performance from leveraging the data vault suffers and thus need specialist constructs to improve performance for querying data

They function like GPS coordinates to find the data at a point-in-time

Poll results: What are PIT tables?

Voter(s): 5

Poll is created on Jan 22, 2021

They are special tables constructed to provide index-on-index joins between a business entity (or relationship) and its satellites - votes: 2 / 40%

40%

They are views constructed to simplify the joins needed to to perform between satellite tables - votes: 2 / 40%

40%

They are deep chasms of of historical data that goes as far back as the data is available - votes: 1 / 20%

20%

They are constructed only when performance from leveraging the data vault suffers and thus need specialist constructs to improve performance for querying data - votes: 5 / 100%

100%

They function like GPS coordinates to find the data at a point-in-time - votes: 3 / 60%

60%

Poll #7: What are PIT tables?

Last Post

Posts: 752

Patrick Cuba

Topic starter

Jan 22, 2021 11:33 am

(@patrick-cuba)

Prominent Member

Joined: 2 years ago

What do QA tables provide?

Topic Tags

PIT point in time query assistance

1 Reply

Forum Statistics

15 Forums

566 Topics

3,285 Posts

2 Online

2,577 Members

Latest Post: Modeling Asana Tasks Our newest member: Henk Teurlings Recent Posts Unread Posts Tags

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed