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: 612

Patrick Cuba

Topic starter

Jan 22, 2021 11:33 am

(@patrick-cuba)

Honorable Member

Joined: 1 year ago

What do QA tables provide?

Topic Tags

PIT point in time query assistance

1 Reply

Forum Statistics

15 Forums

496 Topics

2,969 Posts

2 Online

2,461 Members

Latest Post: Redefining Satellite column definitions? Our newest member: Jas Phul 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

Poll #7: What are PIT tables?

Our Mission:

Important Links