Introduction to Informatica Data Validation Option Training
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. To become proficient in this trending domain join Ides Trainings where you can gain complete knowledge on this. Ides Trainings provides you with Online, Corporate and Classroom training. We provide Virtual Job Support as well.
Prerequisites of Informatica Data Validation Option Training
To learn this course, one should have basic knowledge of
Database concepts
SQL experience
PowerCenter
Course Outline of Informatica Data Validation Option Training
Course Name: Informatica Data Validation Option (DVO) Training
Mode of Training: We provide Online, Corporate and Classroom training. We provide Virtual Job Support as well.
Duration of Course: 18 Hours (Can be customized as per the requirement)
Trainer Experience: 15+ years
Timings: According to one’s feasibility.
Batch Type: Regular, Weekends and Fast track
Do you provide materials: Yes, if you register with Ides Trainings, we will provide materials for Informatica Data Validation Option training.
Course Fee: After registering on our website, one of our coordinators will contact you for further details.
Online Mode: WEBEX, GoToMeeting or SKYPE.
Basic Requirement: Good Internet Speed, Headset.
Backup session: We will provide backup session in case the student misses the class.
Course Content of Informatica Data Validation Option Training
Module 1: WHAT IS DATA VALIDATION OPTION?
1.1 Overview
1.2 DVO Architecture
1.3 DVO Benefits
1.4 DVO interface
1.5 Test Types
Module 2: USE TABLE PAIRS & BASIC TABLE PAIR TESTS
2.1 Use of table pairs in DVO
2.2 Basic table pair tests
Module 3: AGGREGATE TESTS
3.1 Aggregate test types
3.2 Best practices for aggregate testing
3.3 Run and evaluate test results
3.4 Create table pairs and aggregate tests
Module 4: SET TESTS
4.1 Set Test Types
4.2 Experience creating set tests
Module 5: VALUE TESTS
5.1 Value test types & functionality
5.2 Set up and run value tests
Module 6: EXPRESSION TESTING – INFORMATICA DVO TRAINING
6.1 How to use Expressions in testing
6.2 Relationship between DVO Expressions & PWC Expressions
Module 7: PWC & DVO REPOSITORIES
7.1 Relationship between DVO Repository & PWC Repository
Module 8: FILTERING DATA
8.1 Set up WHERE and TEST conditions
8.2 How they function
Module 9: SINGLE TABLE CONSTRAINTS
9.1 Specify the usage of Single Table constraints
9.2 Set up Single Table Constraints
9.3 Single Pair testing vs Table pair testing
Module 10: DVO METHODOLOGY
10.1 Guidelines to configure a DVO approach to testing
Module 11: AUTOMATIC TEST GENERATION
11.1 Overview
11.2 Types of Automated Tests
11.3 Best practices
11.4 Generating Tests Automatically
Module 12: GENERATING REPORTS
12.1 Overview
12.2 Types of Reports
12.3 Run Reports on test results
Module 13: SQL VIEWS – INFORMATICA DVO TRAINING
13.1 Overview
13.2 Advantages & Limitations
13.3 Definition
13.4 Creating and Using SQL Views
Module 14: LOOKUP VIEWS
14.1 Overview
14.2 Lookup View Properties
14.3 Lookup View Example
14.4 Creating and using Lookup Views
Module 15: JOIN VIEWS
15.1 Overview
15.2 Performance on Join Views
15.3 Types of joins available
15.4 Create and run tests that utilize Join Views
Module 16: RESOLVE ERRORS
16.1 PWC Role
16.2 Troubleshooting Initial & On-going Errors
16.3 Troubleshoot DVO errors occurring on running tests
Module 17: EXPORT AND IMPORT DVO METADATA
17.1 Overview
17.2 What objects can you import and export
17.3 Exporting Metadata
17.4 Importing Metadata
Module 18: DVO’S CAPABILITIES AT COMMAND LINE
18.1 Overview
18.2 DVOCmd Location
18.3 DVOCmd Syntax
Overview
The DVO platform interoperates with the broadest possible range of disparate standards, systems and applications. This unbiased and universal view makes informatica unique in today’s market as a leader in the data integration platform. Informatica Power Center is a premium data integration solution available today. The reason it provides the best solution for the large enterprises is that its database is neutral and hence can communicate with any database and it is the most powerful data transformations tool and converts one application’s data to another format.
Informatica DVO and Power Center
DVO is tightly integrated with Informatica Power Center. Informatica Power Center and Informatica DVO are two different tools. Informatica Power Center is an ETL tool where as DVO is a data validation and testing tool. DVO and power center have a separate license. Without power center you cannot configure or use DVO.
Informatica DVO Architecture
DVO consists of a desktop client and its own combined metadata repository and warehouse. The metadata repository and the warehouse is a single database in which DVO metadata and the results of test cases are stored in predefined warehouse tables.
Informatica DVO Database
You have to create a separate database specific to DVO. The database will have all the DVO metadata tables, test definitions and test results are stored in the database. The database will also have predefined warehouse views on which all reporting occurs.
Configure DVO
When you configure DVO, you need to define source power center repository and target power center repository.
Source Power center repository:
DVO uses the source power center repository to import the metadata that is source objects, target objects, folder list and connection objects from the power center.
For instance, let’s say you need to compare data between a flat file and relational table. In order to create the test cases in DVO on these objects, you need to first import the flat file and relational table in the source power center repository. Then, refresh the folder in DVO for you to see the objects in DVO. Any source, target or connection object cannot be imported in DVO directly. The objects can only be imported from the source power center repository.
Target Power center repository:
When you create test cases and execute in DVO, DVO automatically generates informatica mapping, session, workflow to compare and validate source and target data. The generated informatica objects are stored in the target power center repository. You can configure the same power center repository as source and target repository in DVO.
DVO connects to power center source repository and imports the required objects i.e., source, target, folder list and connection objects. You create test cases in DVO client and the metadata like the source, target, connection and the DVO test case details are stored in the DVO repository. The test case execution is handled by target power center repository. DVO will generate the mapping, session and workflow based on the DVO test case configuration defined in the DVO client. Power center will access the data being tested using the connection information which is specified in the DVO test case configuration and applies the DVO test case configuration to the data.
Test results like pass or fail, test details, error rows and data values are loaded by target power center repository into the DVO warehouse. Users can view test results in the DVO client and users can generate different reports which are generated from warehouse.
Conclusion
Informatica DVO has a very high demand in today’s world. Ides Trainings let’s you gain the complete knowledge on Informatica DVO from beginning to advance level. We provide hands-on experience in this course and let you prove your ability through online assessment tools. To know more about this course contact our help desk or the details provided. Register with Ides Trainings to get the best Informatica Data Validation Option training.
Frequently Asked Questions (FAQs)
1. What will one learn in Informatica DVO training?
If one learns this course, you will get the following:
ETL scenarios using Informatica
Informatica overview
Data Integration and data warehousing fundamentals
Informatica Power transformations
And many more.
2. Who should take this Informatica DVO training?
This course can be taken by Data Integration developers, informatica PowerCenter administrators, BI/ETL/DW professionals, Database developers and developer managers.
3. What is the average salary of Informatica DVO professional?
The average salary of Informatica DVO professional is $130K.
4. What are the three types of data validation?
Code Check
Range Check
Format Check are the three types of data validation.
5. Can we delete any validation rule directly?
You can delete validation rules in the same way as normal assets. You cannot delete a validation rule if it is assigned to an asset type.