Skip to content
Main Menu
About
Menu Toggle
About Certification
Authorized Training Partners
Customer Successes
About Data Vault
Standards Board
Our Partners
Shop
Menu Toggle
Individual Membership
Team Membership
Gift a Membership!
Courses
Menu Toggle
Instructor-Led CDVP2
E-Learning
Services
Menu Toggle
Kick Start Engagement
Reviews / Assessments
Discussions
Blog
Login-admin
Help
Menu Toggle
Contact Us
Knowledge Base
We are currently experiencing issues with our membership area. We are in Maintenance Mode until further notice.
Read More here...
Forums
Recent Posts
Forums
Members Discussions
Technical Discussio...
Poll #7: What are P...
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%
2
40%
They are views constructed to simplify the joins needed to to perform between satellite tables
- votes: 2 / 40%
2
40%
They are deep chasms of of historical data that goes as far back as the data is available
- votes: 1 / 20%
1
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%
5
100%
They function like GPS coordinates to find the data at a point-in-time
- votes: 3 / 60%
3
60%
Poll #7: What are PIT tables?
Last Post
Posts: 500
Patrick Cuba
Topic starter
Jan 22, 2021 11:33 am
(@patrick-cuba)
Honorable Member
Joined: 1 year ago
What do QA tables provide?
Reply
Topic Tags
PIT
point in time
query assistance
1
Reply
‹
›
×
‹
›
×