How to Use a Basic Data Validation Script in Oracle

Publicado el: 10 julio 2021
en el canal de: DataResearchLabs

1,437

This video walks you through how to use the basic data validation script in Oracle. It includes 66 sample test cases demonstrating one of each type of data validation check, from table level row counts, key checks, data mismatches, and heuristics to field level numeric-, date-, and text-specific checks. All the SQL validation test cases run sequentially in Oracle SQL Developer, returning the test id, the test status (pass or fail), and the test description. Only one row is returned per validation test. To keep the process simple, output is streamed to the console (screen as text, not grids).

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:08 - Overview: The Basic Data Validation Script
0:25 - Step 1 - Download & Install Oracle SQL Developer
1:10 - Step 2 - Download & Deploy Demo Data
1:39 - Step 3 - Download Basic Data Validation Script
1:50 - Step 4 - Review Basic Data Validation Script
4:30 - Step 5 - Execute Basic Data Validation Script
5:18 - Next Steps - Build Your Own Validation Test Script
8:14 - The End

Downloads:
Basic Script: https://raw.githubusercontent.com/Dat...
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

En esta página del sitio puede ver el video en línea How to Use a Basic Data Validation Script in Oracle de Duración hora minuto segunda en buena calidad , que subió el usuario DataResearchLabs 10 julio 2021, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 1,437 veces y le gustó 6 a los espectadores. Disfruta viendo!