ETL Testing: How to Achieve 100% Data Validation (QuerySurge)

Comments

Post a Comment

Popular posts from this blog

Informatica DVO

What is Data Validation Option ? What can be tested ? To answer above two questions, Data Validation Option is a ETL Testing tool which comes along with power center and 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 in Informatica Data Validation stages A typical workflow or stages for data validation consists of multiple tasks- 1. Data Validation Option reads one or more Power Center metadata repositories 2. We define the validation rules(creation of tests) in Data Validation Option 3. 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: ...
Read more

Informatica DVO installation steps

1      About This Article The purpose of this article is to explain the steps involved in installing and configuring Data Validation Option for usage with Informatica PowerCenter installed on a local machine. Informatica PowerCenter Server can be installed on a remote machine other than the local machine. But installation of Data Validation Option should be done on the same machine as the Informatica PowerCenter Client. 2      Functional Overview Informatica Data Validation Option enables you to test and validate data. It requires the installation of, and does much of its work through, Informatica PowerCenter. Data Validation Option reads table definitions from PowerCenter metadata repositories, and checks the data at either end of the process. It does not check the correctness of transformations or mappings. Data Validation Option identifies problems or inconsistencies. It does not attempt to identi...
Read more

Data Migration Testing Startegy

Image
1.   Purpose of the Article The purpose of this Aricle is to describe the different test stages that will be performed; how the testing will be prepared and executed for each stage, and the criteria that need to be met before transition from one stage to the next can occu r. 2.   Phases involved in Data Migration Testing Below are the phases involved in testing data migration. ·         Fusion ·         Release 1.       Design 2.       Implementation a)       Ear b)       Iterations 3.       SIT (System Integration Testing) 4.       UAT (User Acceptance Testing) 2.1.         Fusion (Discover and Define) In this Phase the requirements for the...
Read more