importing queries using mass import tool
TRANSCRIPT
![Page 1: Importing Queries using Mass Import Tool](https://reader033.vdocuments.us/reader033/viewer/2022042600/58f130841a28abe07f8b4605/html5/thumbnails/1.jpg)
ETL Validator#1 Data Testing Automation Platform
Importing Queries through Excel
![Page 2: Importing Queries using Mass Import Tool](https://reader033.vdocuments.us/reader033/viewer/2022042600/58f130841a28abe07f8b4605/html5/thumbnails/2.jpg)
Query Import• As a user I have an existing CSV file with a list
of all source and target queries. I want to quickly import them into ETLV to get started
![Page 3: Importing Queries using Mass Import Tool](https://reader033.vdocuments.us/reader033/viewer/2022042600/58f130841a28abe07f8b4605/html5/thumbnails/3.jpg)
• Prepare the CSV file and ensure proper format (next slide)
![Page 4: Importing Queries using Mass Import Tool](https://reader033.vdocuments.us/reader033/viewer/2022042600/58f130841a28abe07f8b4605/html5/thumbnails/4.jpg)
CSV Fields• Ensure that the Excel has the following
parameters in this order
optional
Adi Buddhavarapu
![Page 5: Importing Queries using Mass Import Tool](https://reader033.vdocuments.us/reader033/viewer/2022042600/58f130841a28abe07f8b4605/html5/thumbnails/5.jpg)
Select Data Migration Wizard
![Page 6: Importing Queries using Mass Import Tool](https://reader033.vdocuments.us/reader033/viewer/2022042600/58f130841a28abe07f8b4605/html5/thumbnails/6.jpg)
Select Connections
![Page 7: Importing Queries using Mass Import Tool](https://reader033.vdocuments.us/reader033/viewer/2022042600/58f130841a28abe07f8b4605/html5/thumbnails/7.jpg)
Select
![Page 8: Importing Queries using Mass Import Tool](https://reader033.vdocuments.us/reader033/viewer/2022042600/58f130841a28abe07f8b4605/html5/thumbnails/8.jpg)
Select File
![Page 9: Importing Queries using Mass Import Tool](https://reader033.vdocuments.us/reader033/viewer/2022042600/58f130841a28abe07f8b4605/html5/thumbnails/9.jpg)
Update Mapping & Join Conditions(optional)
![Page 10: Importing Queries using Mass Import Tool](https://reader033.vdocuments.us/reader033/viewer/2022042600/58f130841a28abe07f8b4605/html5/thumbnails/10.jpg)
![Page 11: Importing Queries using Mass Import Tool](https://reader033.vdocuments.us/reader033/viewer/2022042600/58f130841a28abe07f8b4605/html5/thumbnails/11.jpg)
Click on Generate
![Page 12: Importing Queries using Mass Import Tool](https://reader033.vdocuments.us/reader033/viewer/2022042600/58f130841a28abe07f8b4605/html5/thumbnails/12.jpg)
Log displays errors if there is a problem
![Page 13: Importing Queries using Mass Import Tool](https://reader033.vdocuments.us/reader033/viewer/2022042600/58f130841a28abe07f8b4605/html5/thumbnails/13.jpg)
Once you click on “Generate”, ETLV will automatically create “Query Test Case” type of test cases (one for each row in the CSV file)