etl validator: table to table comparison
DESCRIPTION
Testing, Table Comparison, Source to TargetTRANSCRIPT
![Page 1: ETL Validator: Table to Table Comparison](https://reader034.vdocuments.us/reader034/viewer/2022052400/5597919c1a28ab3d798b4607/html5/thumbnails/1.jpg)
<Insert Picture Here>
datagapsThe data testing company
Table to Table Comparison using ETL Validator
![Page 2: ETL Validator: Table to Table Comparison](https://reader034.vdocuments.us/reader034/viewer/2022052400/5597919c1a28ab3d798b4607/html5/thumbnails/2.jpg)
Objective
• As a QA Engineer, I want to
compare the data between two
tables
![Page 3: ETL Validator: Table to Table Comparison](https://reader034.vdocuments.us/reader034/viewer/2022052400/5597919c1a28ab3d798b4607/html5/thumbnails/3.jpg)
•Login
![Page 4: ETL Validator: Table to Table Comparison](https://reader034.vdocuments.us/reader034/viewer/2022052400/5597919c1a28ab3d798b4607/html5/thumbnails/4.jpg)
• Verification: Once done (all
green), user will automatically see
the home screen.
![Page 5: ETL Validator: Table to Table Comparison](https://reader034.vdocuments.us/reader034/viewer/2022052400/5597919c1a28ab3d798b4607/html5/thumbnails/5.jpg)
• Click on “Connection” to view
existing database connections
![Page 6: ETL Validator: Table to Table Comparison](https://reader034.vdocuments.us/reader034/viewer/2022052400/5597919c1a28ab3d798b4607/html5/thumbnails/6.jpg)
• This screen will display existing
connections.
![Page 7: ETL Validator: Table to Table Comparison](https://reader034.vdocuments.us/reader034/viewer/2022052400/5597919c1a28ab3d798b4607/html5/thumbnails/7.jpg)
• Click on new Data Source and add
connection details
![Page 8: ETL Validator: Table to Table Comparison](https://reader034.vdocuments.us/reader034/viewer/2022052400/5597919c1a28ab3d798b4607/html5/thumbnails/8.jpg)
• Now, you are ready to create tests.
Click on the “Menu” icon on the top
left.
![Page 9: ETL Validator: Table to Table Comparison](https://reader034.vdocuments.us/reader034/viewer/2022052400/5597919c1a28ab3d798b4607/html5/thumbnails/9.jpg)
• Select your Target and Source
• Click on Next (arrow at the bottom)
![Page 10: ETL Validator: Table to Table Comparison](https://reader034.vdocuments.us/reader034/viewer/2022052400/5597919c1a28ab3d798b4607/html5/thumbnails/10.jpg)
• Click on “Query Builder”
![Page 11: ETL Validator: Table to Table Comparison](https://reader034.vdocuments.us/reader034/viewer/2022052400/5597919c1a28ab3d798b4607/html5/thumbnails/11.jpg)
Target Source
![Page 12: ETL Validator: Table to Table Comparison](https://reader034.vdocuments.us/reader034/viewer/2022052400/5597919c1a28ab3d798b4607/html5/thumbnails/12.jpg)
Select
Target Table
![Page 13: ETL Validator: Table to Table Comparison](https://reader034.vdocuments.us/reader034/viewer/2022052400/5597919c1a28ab3d798b4607/html5/thumbnails/13.jpg)
Select
Source Table
Click on
Save
![Page 14: ETL Validator: Table to Table Comparison](https://reader034.vdocuments.us/reader034/viewer/2022052400/5597919c1a28ab3d798b4607/html5/thumbnails/14.jpg)
Queries get populated
![Page 15: ETL Validator: Table to Table Comparison](https://reader034.vdocuments.us/reader034/viewer/2022052400/5597919c1a28ab3d798b4607/html5/thumbnails/15.jpg)
Execute
(optional)
Execute
(optional)
![Page 16: ETL Validator: Table to Table Comparison](https://reader034.vdocuments.us/reader034/viewer/2022052400/5597919c1a28ab3d798b4607/html5/thumbnails/16.jpg)
Select Join Condition and Columns to be
compared
![Page 17: ETL Validator: Table to Table Comparison](https://reader034.vdocuments.us/reader034/viewer/2022052400/5597919c1a28ab3d798b4607/html5/thumbnails/17.jpg)
Execute test by clicking on Run
![Page 18: ETL Validator: Table to Table Comparison](https://reader034.vdocuments.us/reader034/viewer/2022052400/5597919c1a28ab3d798b4607/html5/thumbnails/18.jpg)
Three Tabs show up if there is a problem
![Page 19: ETL Validator: Table to Table Comparison](https://reader034.vdocuments.us/reader034/viewer/2022052400/5597919c1a28ab3d798b4607/html5/thumbnails/19.jpg)
1. Data that is in Source but not in Target
![Page 20: ETL Validator: Table to Table Comparison](https://reader034.vdocuments.us/reader034/viewer/2022052400/5597919c1a28ab3d798b4607/html5/thumbnails/20.jpg)
2. Data that is in Target but not in Source
![Page 21: ETL Validator: Table to Table Comparison](https://reader034.vdocuments.us/reader034/viewer/2022052400/5597919c1a28ab3d798b4607/html5/thumbnails/21.jpg)
3. Data differences (if any)
![Page 22: ETL Validator: Table to Table Comparison](https://reader034.vdocuments.us/reader034/viewer/2022052400/5597919c1a28ab3d798b4607/html5/thumbnails/22.jpg)
Now, the test case can be packaged
into a test plan and scheduled
![Page 23: ETL Validator: Table to Table Comparison](https://reader034.vdocuments.us/reader034/viewer/2022052400/5597919c1a28ab3d798b4607/html5/thumbnails/23.jpg)
More Resources
•http://www.datagaps.com
•http://youtube.com/datagaps
•http://www.twitter.com/datagaps