1 / 50

Informatica DVO

Informatica DVO. Informatica DVO Walkthrough By -Ajay Date : 03/26/2019. Agenda. Motivation –Why DVO ? Introduction – DVO DVO Architecture Features supported in DVO Key pointers on DVO Reports Generation Demo Questions?. Motivation- Why DVO.

wbenson
Download Presentation

Informatica DVO

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Informatica DVO Informatica DVO Walkthrough By -Ajay Date: 03/26/2019

  2. Agenda • Motivation –Why DVO ? • Introduction – DVO • DVO Architecture • Features supported in DVO • Key pointers on DVO • Reports Generation • Demo • Questions?

  3. Motivation- Why DVO • Huge amount of data .What should I do ?? • Large volumes of data in heterogeneous environments • Manual Vs Automation • Regression Test • Test Results (Reporting) • Data Completeness and Accuracy

  4. 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

  5. DVO Architecture

  6. 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

  7. What can’t be Tested vs What can be Tested What can’t be Tested ? • Mappings and Workflows can’t be tested • It doesn’t attempt to identify Bug in ETL process • Can’t Identify the source of inconsistencies What can be Tested ? • Only data validation can be done • DVO only reads table definition from PowerCenter Metadata repositories ,and checks the data at either end of the process • Can identify inconsistency in data

  8. POC RESULTS

  9. 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)

  10. Power center Steps: Launch Informatica Power centerdesigner and connect to INFAPCD1 Repository

  11. Navigate to PGI_DVO_POC Folder

  12. Import Table to Informatica

  13. Open table in Source Analyzer

  14. Launch Informatica DVO Client

  15. Navigate to PGI_DVO_POC Folder and refresh that folder

  16. Refresh PGI_DVO_POC folder

  17. 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

  18. Add Test case to Single Table Test and add constraints for testing

  19. Run Single table test

  20. Table Pair(2 Different Table through SQL View

  21. Contd..

  22. Contd..

  23. Table Pair(2 Different database through Table Pair feature

  24. Single Table Constraint using single table feature

  25. Contd..

  26. Contd..

  27. Contd..

  28. Single Table constraint check through SQL view

  29. Contd..

  30. Flat File Comparison using SQL view and table pair feature

  31. Contd..

  32. Contd..

  33. Contd..

  34. Report Generation

  35. Contd..

  36. Summary Of Test Result

  37. Table Pair Summary

  38. Contd..

  39. Detailed Test Result

  40. Aggregate View

  41. Join view

  42. Contd..

  43. Queries??

More Related