Oracle Data Validation Examples: Null Rates, Value Thresholds, and Table Schema or Data Diffs

Pubblicato il: 29 giugno 2021
sul canale di: DataResearchLabs

278

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

In questa pagina del sito puoi guardare il video online Oracle Data Validation Examples: Null Rates, Value Thresholds, and Table Schema or Data Diffs della durata di ore minuti seconda in buona qualità , che l'utente ha caricato DataResearchLabs 29 giugno 2021, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 278 volte e gli è piaciuto 0 spettatori. Buona visione!

889