Part 3: [FULL]How I Automated Full Reconciliation Testing (In just 3 Steps) скачать в хорошем качестве

Part 3: [FULL]How I Automated Full Reconciliation Testing (In just 3 Steps)

This video walks through how to automate FULL end-to-end reconciliation testing. I demonstrate how to run a full reconciliation process, then show how to validate missing or extra record counts against expected results. Finally, I bring it all together by running the process with Runner, Maven, or command-line tools to make your testing reliable, repeatable, and easy to automate. GitHub Project Link (Download and Practice At Home): 👇 https://github.com/ETL-TESTING/hellow... Watch Other Parts(playlist): 👇    • AUTOMATED RECONCILIATION TESTING(QA)   Chapters: 00:00:00 Intro: Automating the final part of Reconciliation Testing 00:00:11 Recap: Part 1 and Part 2 of the series 00:01:03 Reviewing the automation script and DDL creation 00:01:50 High-level view of the process so far 00:02:40 Pro tip: JSON comments in automation scripts 00:03:36 Strategy for the final reconciliation bit 00:04:51 Step 1: Running the full reconciliation process 00:05:48 Setting up the execution step in the framework 00:06:48 Creating the SQL file for reconciliation 00:07:40 Step 2: Defining and fitting assertions 00:08:14 Testing the reconciliation query in SQL workbench 00:10:46 Running the script and verifying initial results 00:12:46 Step 3: Validating status and data mismatches 00:15:22 Summary of the completed automation script 00:15:46 Introducing intentional errors to test the catch mechanism 00:18:19 Modifying the source CSV to create a mismatch 00:19:07 Analyzing a failed reconciliation test 00:21:26 Conclusion and next steps for reporting #DataReconciliation #TestAutomation #DataEngineering #ETLTesting #AutomationTesting #DataQuality #SoftwareTesting #DataPipeline #QAAutomation #DataIntegrity #nocodetesting #DataScience #DatabaseTesting