Oracle Data Validation Examples: Null Rates, Value Thresholds, and Table Schema or Data Diffs
This video walks you through 5 powerful advanced data validation test case examples. These table-level tests cover thresholds for column null rates and value frequencies observed. These tests also covering monitoring table structure and table data changes.
You can refactor and re-use the samples in your projects. The scripts in the demo are all out on Github along with 66 total sample validation tests along with a basic and an advanced script for automating the tests.
------ Chapter Timestamps (click to jump forward): ----------------------------
0:00 - Intro
0:12 - Introducing Rule Set #3 - Heuristic Thresholds
0:23 - Demo: T008 - Null Rate Thresholds
5:27 - Demo: T009 - Value Frequency Thresholds
8:25 - Introducing Rule Set #8 - Diff Checks
8:33 - Demo: T059 - Table Structure (Schema) Changes
13:00 - Demo: T060 - Table Data Changes (Static SQL Snapshot)
15:25 - Demo: T061 - Table Data Changes (Dynamic Table Compare)
19:21 - How to Download SQL Scripts in this Video
20:42 - The End
Downloads:
Rule Set #3: https://github.com/DataResearchLabs/s...
Rule Set #8: https://github.com/DataResearchLabs/s...
Multi-Platform Data Validation Scripts: https://github.com/DataResearchLabs/s...
Watch related playlist videos:
• Oracle SQL Scripts for Data Analysts
Connect with me on social media:
LinkedIn: / mpiercead576
YouTube: / @dataresearchlabs
GitHub: https://github.com/DataResearchLabs
Subscribe to my YouTube Channel:
/ @dataresearchlabs
Background Music (via YouTube "always free" Audio):
"Rewind" by Ofshane: / @ofshane
#Oracle #automation #datavalidation
Auf dieser Seite können Sie das Online-Video Oracle Data Validation Examples: Null Rates, Value Thresholds, and Table Schema or Data Diffs mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer DataResearchLabs 29 Juni 2021 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 278 Mal angesehen und es wurde von 0 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
