Informatica DVO Walkthrough By Ajay Date 03262019 Classification
Informatica DVO Walkthrough By -Ajay Date: 03/26/2019 Classification: Internal Use
Agenda Motivation –Why DVO ? Introduction – DVO Architecture Features supported in DVO Key pointers on DVO Reports Generation Demo � Questions? Classification: Internal Use
Motivation- Why DVO Huge amount of data. What should I do ? ? Large volumes of data in heterogeneous environments Manual Vs Automation Regression Test Results (Reporting) Data Completeness and Accuracy Classification: Internal Use
Introduction – DVO Data validation Option is an Automated ETL Testing tool which comes along with power center and enables to test and validate data Helps in verifying the completeness and accuracy of data after data migration Reads table definitions from Power Center metadata repositories Classification: Internal Use
DVO Architecture Classification: Internal Use
Features supported in DVO Table Pair Single Table Constraints SQL Views Lookup Views Join Views Aggregate Views Import and Export of Test XML and Flat File Test Aggregate Test and Expression Report generation Classification: Internal Use
What can’t be Tested vs What can be Tested What can’t be Tested ? What can be Tested ? • • Only data validation can be done • DVO only reads table definition from Power. Center Metadata repositories , and checks the data at either end of the process Mappings and Workflows can’t be tested • It doesn’t attempt to identify Bug in ETL process • Can’t Identify the source of inconsistencies Classification: Internal Use Can identify inconsistency in data
POC RESULTS Test Type Test Results & Efficiency Metrics through Informatic a DVO # Features Tested 3 #Test case Automated 100 DVO # Records tested 232685 29 sec Test All data , not just selected records Easily Test heterogeneous data (e. g. FF vs DBMS) Minimize writing SQL Full Audit trail of Test Activities Lower Project Risk Easy. Internal GUI Use Classification: Efficiency through SQL server 52 sec Manual Testing
DVO POC Demo Table Pair (2 Different database through SQL View) Table Pair ( 2 Different database through Table Pair) Single Table (Aggregates and Constraint Check through SQL View) Single Table (Aggregates and Constraint Check through Table Pair) Flat File (Through SQL View) Fat File(Through Table Pair) Table Pair ( 2 homogenous database through Join View) Classification: Internal Use
Power center Steps: Launch Informatica Power center designer and connect to INFAPCD 1 Repository Classification: Internal Use
Navigate to PGI_DVO_POC Folder Classification: Internal Use
Import Table to Informatica Classification: Internal Use
Open table in Source Analyzer Classification: Internal Use
Launch Informatica DVO Client Classification: Internal Use
Navigate to PGI_DVO_POC Folder and refresh that folder Classification: Internal Use
Refresh PGI_DVO_POC folder Classification: Internal Use
Right Click on AJAY_PGI_DEST_POC folder and Add Single Table Test. Browse to locate Table and Provide connection detail for table. Specify one primary key Classification: Internal Use
Add Test case to Single Table Test and add constraints for testing Classification: Internal Use
Run Single table test Classification: Internal Use
Table Pair(2 Different Table through SQL View Classification: Internal Use
Contd. . Classification: Internal Use
Contd. . Classification: Internal Use
Table Pair(2 Different database through Table Pair feature Classification: Internal Use
Single Table Constraint usingle table feature Classification: Internal Use
Contd. . Classification: Internal Use
Contd. . Classification: Internal Use
Contd. . Classification: Internal Use
Single Table constraint check through SQL view Classification: Internal Use
Contd. . Classification: Internal Use
Flat File Comparison using SQL view and table pair feature Classification: Internal Use
Contd. . Classification: Internal Use
Contd. . Classification: Internal Use
Contd. . Classification: Internal Use
Classification: Internal Use
Classification: Internal Use
Classification: Internal Use
Classification: Internal Use
Classification: Internal Use
Classification: Internal Use
Report Generation Classification: Internal Use
Contd. . Classification: Internal Use
Summary Of Test Result Classification: Internal Use
Table Pair Summary Classification: Internal Use
Contd. . Classification: Internal Use
Detailed Test Result Classification: Internal Use
Aggregate View Classification: Internal Use
Join view Classification: Internal Use
Contd. . Classification: Internal Use
Classification: Internal Use
Queries? ? Classification: Internal Use
- Slides: 50