w ww globalonlinetraining s com n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Informatica DVO Training | Data Validation Option Online Course - GOT PowerPoint Presentation
Download Presentation
Informatica DVO Training | Data Validation Option Online Course - GOT

Loading in 2 Seconds...

play fullscreen
1 / 16

Informatica DVO Training | Data Validation Option Online Course - GOT - PowerPoint PPT Presentation


  • 56 Views
  • Uploaded on

Informatica DVO Training enables developers to create rules to test the data.Data Validation Option Online Training is the process of verifying the accuracy.\nFor more info visit : https://www.globalonlinetrainings.com/informatica-dvo-training

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Informatica DVO Training | Data Validation Option Online Course - GOT' - kalyani098


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
w ww globalonlinetraining s com
www.globalonlinetrainings.com

Informatica DVOTraining

Skype:Global.onlinetrainings

USA:+1-516-8586-242

UK:+44 (0)203 3710077

info@globalonlinetrainings.com/ +91-4060 501418

global online trainings to give an overview

Global OnlineTrainings

To give an overview Global Online Trainings is a leading training services corporation specializing in providing Online Trainings and Corporate Trainings to individuals and Enterprises.

www.globalonlinetrainings.com

Our high quality, competitive and effective training services makes us the best in this field our professional team carries excellent instructional experience through many years and understands the complexity of the technology and methods of trainingdelivery.

We provide the trainings with Subject Matter Experts (SMEs) who has good experience in their primary skills, currently we have more tutors in all the technologies for online trainings and corporatetrainings.

We provide trainings for belowtechnologies

SAP (AllModules)

Oracle (All Modules)

SAS (AllModules)

IBMTools

MicrosoftApplications

Web Technologies and Othertechnologies

Middlewaretools

info@globalonlinetrainings.com/ +91-4060 501418

informatica dvo training introduction
Informatica DVO TrainingIntroduction:

www.globalonlinetrainings.com

Informatica Data Validation Option is the process of verifying the accuracy and completeness of data after a data migration, replication, integration or other similar movement or transformation exercise. Valid and accurate target data indicates that the data extraction, transformation, and loading (ETL) processes are working as expected and are safe to use. DVO integrates with the Informatica PowerCenter Repository and Integration Services and enables developers and business analyststo create rules to test thedata.

Informatica DVO Training training is rendered by best subject matter experts and the tutorials prepared by these expert industry allied tutors are made with latest industry updates. Classes are available for individual as well as for corporate batches on demand. Call the help desk for more details for online Informatica DVO training’s and itsdetails.

info@globalonlinetrainings.com/ +91-4060 501418

w ww globalonlinetraining s com 1
www.globalonlinetrainings.com

INFORMATICA DATA VALIDATION OPTION ONLINE TRAINING COURSECONTENT

TOPIC 1: WHAT IS DATA VALIDATIONOPTION?

Overview

DVOArchitecture DVO Benefits DVO interface TestTypes

TOPIC 2: USE TABLE PAIRS & BASIC TABLE PAIRTESTS

Use of table pairs inDVO Basic table pairtests

TOPIC 3: AGGREGATETESTS

Aggregate testtypes

Best practices for aggregatetesting Run and evaluate testresults

Create table pairs and aggregatetests

info@globalonlinetrainings.com/ +91-4060 501418

w ww globalonlinetraining s com 2
www.globalonlinetrainings.com

INFORMATICA DATA VALIDATION OPTION ONLINE TRAINING COURSECONTENT

TOPIC 4: SETTESTS

Set TestTypes

Experience creating settests

TOPIC 5: VALUETESTS

Value test types & functionality

Set up and run valuetests

TOPIC 6: EXPRESSIONTESTING

How to use Expressions intesting

Relationship between DVO Expressions & PWCExpressions

TOPIC 7: PWC & DVOREPOSITORIES

Relationship between DVO Repository & PWCRepository

TOPIC 8: FILTERINGDATA

Set up WHERE and TESTconditions How theyfunction

info@globalonlinetrainings.com/ +91-4060 501418

w ww globalonlinetraining s com 3
www.globalonlinetrainings.com

INFORMATICA DATA VALIDATION OPTION ONLINE TRAINING COURSECONTENT

TOPIC 9: SINGLE TABLE CONSTRAINTS

Specify the usage of Single Tableconstraints

Set up Single TableConstraints

Single Pair testing vs Table pairtesting

TOPIC 10: DVOMETHODOLOGY

Guidelines to configure a DVO approach totesting

TOPIC 11: AUTOMATIC TESTGENERATION

Overview

Types of AutomatedTests

Best practices

Generating TestsAutomatically

TOPIC 12: GENERATINGREPORTS

Overview

Types ofReports

Run Reports on testresults

info@globalonlinetrainings.com/ +91-4060 501418

w ww globalonlinetraining s com 4
www.globalonlinetrainings.com

INFORMATICA DATA VALIDATION OPTION ONLINE TRAINING COURSECONTENT

TOPIC 13: SQLVIEWS

Overview

Advantages &Limitations Definition

Creating and Using SQLViews

TOPIC 14: LOOKUPVIEWS

Overview

Lookup ViewProperties Lookup ViewExample

Creating and using LookupViews

TOPIC 15: JOINVIEWS

Overview

Performance on JoinViews Types of joinsavailable

Create and run tests that utilize JoinViews

TOPIC 16: RESOLVEERRORS

PWCRole

Troubleshooting Initial & On-goingErrors

Troubleshoot DVO errors occurring on runningtests

info@globalonlinetrainings.com/ +91-4060 501418

w ww globalonlinetraining s com 5
www.globalonlinetrainings.com

INFORMATICA DATA VALIDATION OPTION ONLINE TRAINING COURSECONTENT

TOPIC 17: EXPORT AND IMPORT DVOMETADATA

Overview

What objects can you import andexport ExportingMetadata

ImportingMetadata

TOPIC 18: DVO’S CAPABILITIES AT COMMANDLINE

Overview DVOCmdLocation DVOCmd Syntax Examples

info@globalonlinetrainings.com/ +91-4060 501418

w ww globalonlinetraining s com 6
www.globalonlinetrainings.com
  • Informatica DVO TrainingArchitecture:
  • Data Validation Option Online Training requires installation and setupof
  • PowerCenter.
  • Source and target data table and file definitions are importedfrom PowerCenter repositories.
  • You set up table pairs and test rules in Data Validation Option. This test metadata is stored in the Data Validation Optionrepository.
  • When the tests are run, DVO communicates with PowerCenter through an API to create appropriate mappings, sessions, and workflows, and to execute them.
  • PowerCenter connects to the data being tested instead of DataValidation Option.
  • After the tests are executed, results are stored in the Data Validation Option repository and displayed in the DVOClient.

info@globalonlinetrainings.com/ +91-4060 501418

w ww globalonlinetraining s com 7
www.globalonlinetrainings.com
  • Typical Data ValidationWorkflow:
  • Data Validation Option reads one or more PowerCenter metadata repositories.
  • You define the validation rules in Informatica DVO Training.
  • You run the rules to ensure the data conforms to the validation rules. When you do this, Data Validation Option performs the followingtasks:

  • Creates and executes all tests throughPowerCenter.
  • Loads results into the DVO results database and displays themin
  • the Informatica DVO TrainingClient.
  • You examine the results and identify sources of inconsistencies in the ETL process or the sourcesystems.
  • You repeat this process for newrecords.

info@globalonlinetrainings.com/ +91-4060 501418

w ww globalonlinetraining s com 8
www.globalonlinetrainings.com
  • Benefits of Informatica DVOTraining:
  • Informatica DVO Training reduces the time required for data validation and production data auditing and verification significantly, eliminating thetraditional methods of validating data by visual inspection, data comparison tools or writing SQL scripts viz row counts, minus queries etc. The risk of validating data by traditional methods is particularly high when there is a larger data set to work with and a higher chance of occurence of humanerrors.
  • Maintaining different test scripts to validate data for different projects is cumbersome. Informatica DVO Training provides a easy-to-use GUI interface to test the rules created for data validations for multipleprojects.
  • No programming skills needed to create validationtests.
  • DVO includes a repository with reporting capabilities to provide acomplete audit trail of all tests and theirresults.
  • It reads data definitions from PowerCenter metadata repositories and can easily deal with data definitionchanges.

info@globalonlinetrainings.com/ +91-4060 501418

w ww globalonlinetraining s com 9
www.globalonlinetrainings.com
  • Key Pointers For Informatica DVO TrainingTesting:
  • Informatica DVO Training tests data only, not mappings or workflows.Testing mappings is unit testing, which is different from datavalidation.
  • Informatica DVO Training only reads table definitions from PowerCenter metadata repositories, and checks the data at either end of the process and will show problemsor inconsistencies only. It does not attempt to identify the bug in the ETLprocess.
  • Do not copy formulas from the ETL mapping into Informatica Data Validation Option Training. If there is an error in the ETL mapping formula, you will replicate it in Informatica DVO Training, and Data Validation Option will not catch it.Therefore, you must always maintain a proper separation between ETL andtesting.
  • Do not try to do everything in Informatica DVO Training. If you think that a particular step can be accomplished more easily with SQL, use SQL. If you run 95%of your validation in Data Validation Option, and can document it with the audit trail, this is more thanenough.

info@globalonlinetrainings.com/ +91-4060 501418

w ww globalonlinetraining s com 10
www.globalonlinetrainings.com

Informatica DVO TrainingUsage:

Validate Data being Transformed – ETL Testing, ETL Reconciliation,Application Migration

Validate if Data is Identical – ETL Migration, Database Migration, ETL VersionUpgrade

What is Data Validation Option?

Informatica DVO Training is a ETL Testing tool which comes along with power centerand enables to test and validate data Data Validation Option reads table definitions from Power Center metadata repositories, and checks the data for inconsistencies Verify that moved or transformed data is complete and accurate and has not been changed because of errors in the movement or transformation process Will not check the correctness of transformations or mappings designed inInformatica.

info@globalonlinetrainings.com/ +91-4060 501418

www globalonlinetrainings com course objectives

www.globalonlinetrainings.com

  • Course Objectives for Informatica DvoTraining:
  • After successfully completing this course, students should be ableto:
  • Develop a high-level understanding of the Informatica DVOTraining architecture andfunctionality.
  • Develop a high-level understanding of test types in general (aggregate, set and value)
  • Develop a high-level understanding of the options that can be chosenwhen
  • creating atest
  • Develop an understanding of how to run tests, and evaluate testresults
  • Obtain experience creating basic aggregate tests, which includeCOUNT, COUNT DISTINCT, COUNT ROWS, SUM, AVG, MIN,MAX.
  • Develop an understanding of value test functions, which include VALUE,and OUTER_VALUE.
  • Obtain experience setting up and running valuetests
  • Develop an understanding of SET tests, which include SetA_in_B,SetB_in_A, Set_AinB, andSet_ANotInB.

info@globalonlinetrainings.com/ +91-4060 501418

w ww globalonlinetraining s com 11
www.globalonlinetrainings.com
  • Informatica DVO Trainingstages:
  • A typical workflow or stages for data validation consists of multipletasks-
  • Informatica DVO Training reads one or more Power Center metadatarepositories
  • We define the validation rules(creation of tests) in Data ValidationOption
  • We run the rules(tests) to ensure the data conforms to the validation rules. When we do this, Data Validation Option performs the following tasks: Creates and executes all tests throughPowerCenter.
  • Loads results into the Data Validation Option results database and displays them in the Data Validation OptionClient.
  • We examine the results and identify data inconsistencies in the ETL process We repeat this process for newrecords.

info@globalonlinetrainings.com/ +91-4060 501418

please reach us on
Please Reach UsOn

www.globalonlinetrainings.com

https://www.globalonlinetrainings.com/informatica-dvo-training/ Email: info@globalonlinetrainings.com

Thankyou….!

info@globalonlinetrainings.com/ +91-4060 501418