Informatica DVO Training Demo Video | Informatica DVO Online Course - GOT
Reach us:
IND: +91-40-6050-1418
USA: +1-516-8586-242
UK:+44 (0)203 371 0077
Email: [email protected]
Skype: Global.onlinetrainings
https://www.globalonlinetrainings.com...
Description: Informatica DVO Training enables developers to create rules to test the data.Data Validation Option Online Training is the process of verifying the accuracy.
Informatica DVO Training Introduction:
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 analysts to create rules to test the data.
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 its details.
INFORMATICA DATA VALIDATION OPTION ONLINE TRAINING COURSE CONTENT:
TOPIC 1: WHAT IS DATA VALIDATION OPTION?
Overview
DVO Architecture
DVO Benefits
DVO interface
Test Types
TOPIC 2: USE TABLE PAIRS & BASIC TABLE PAIR TESTS
Use of table pairs in DVO
Basic table pair tests
TOPIC 3: AGGREGATE TESTS
Aggregate test types
Best practices for aggregate testing
Run and evaluate test results
Create table pairs and aggregate tests
TOPIC 4: SET TESTS
Set Test Types
Experience creating set tests
TOPIC 5: VALUE TESTS
Value test types & functionality
Set up and run value tests
TOPIC 6: EXPRESSION TESTING
How to use Expressions in testing
Relationship between DVO Expressions & PWC Expressions
TOPIC 7: PWC & DVO REPOSITORIES
Relationship between DVO Repository & PWC Repository
TOPIC 8: FILTERING DATA
Set up WHERE and TEST conditions
How they function
TOPIC 9: SINGLE TABLE CONSTRAINTS
Specify the usage of Single Table constraints
Set up Single Table Constraints
Single Pair testing vs Table pair testing
TOPIC 10: DVO METHODOLOGY
Guidelines to configure a DVO approach to testing
TOPIC 11: AUTOMATIC TEST GENERATION
Overview
Types of Automated Tests
Best practices
Generating Tests Automatically
TOPIC 12: GENERATING REPORTS
Overview
Types of Reports
Run Reports on test results
TOPIC 13: SQL VIEWS
Overview
Advantages & Limitations
Definition
Creating and Using SQL Views
TOPIC 14: LOOKUP VIEWS
Overview
Lookup View Properties
Lookup View Example
Creating and using Lookup Views
TOPIC 15: JOIN VIEWS
Overview
Performance on Join Views
Types of joins available
Create and run tests that utilize Join Views
TOPIC 16: RESOLVE ERRORS
PWC Role
Troubleshooting Initial & On-going Errors
Troubleshoot DVO errors occurring on running tests
TOPIC 17: EXPORT AND IMPORT DVO METADATA
Overview
What objects can you import and export
Exporting Metadata
Importing Metadata
TOPIC 18: DVO’S CAPABILITIES AT COMMAND LINE
Overview
DVOCmd Location
DVOCmd Syntax
Examples
Informatica DVO Training Architecture:
Data Validation Option Online Training requires installation and setup of PowerCenter.
Source and target data table and file definitions are imported from PowerCenter repositories.
You set up table pairs and test rules in Data Validation Option. This test metadata is stored in the Data Validation Option repository.
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 Data Validation Option.
After the tests are executed, results are stored in the Data Validation Option repository and displayed in the DVO Client.
Typical Data Validation Workflow:
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 following tasks:
– Creates and executes all tests through PowerCenter.
– Loads results into the DVO results database and displays them in the Informatica DVO Training Client.
You examine the results and identify sources of inconsistencies in the ETL process or the source systems.
You repeat this process for new records.