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