Parameter Files in DVO

We can use parameter file in Informatica DVO while defining the where clause of either table pair or single pair. However there are certain rules in order to use.

We must add the parameters to the parameter file before we can add the parameters to a table pair or single table definition.

The parameters in the parameter file must be in the format
$$parameter name=value.

We need to place the parameter file in a location which is accessible by the Data Validation Option Client or DVOCmd that runs the tests.

If we specify the location of the parameter file in the Data Validation Option Client, enter the parameter file location as a network path.
Example, if the Informatica services runs on Windows, use the following syntax:
\\Host name of the Informatica services machine\shared folder path\parameter file name

If we specify the parameter file on a UNIX machine, the Data Validation Option Client on Windows cannot access the parameter file. In this case, we need to install DVOCmd on the UNIX machine and verify that DVOCmd has access to the parameter file.

We can use a parameter file for one or more table pairs and single tables.

Parameter file option is available if the user is having the enterprise license.

Steps to add a Parameter to a WHERE Clause in Table pair \ Single pair :

1.   We need enterprise license,to use a parameter in the WHERE clause to dynamically change the WHERE clause after each test run.

2.   Create the parameter file and add the parameters as per the above guidelines

3.   Place the parameter file in a location that is accessible by the Data Validation Option Client or the DVOCmd command line that runs the tests that require the parameters as per the above guidelines

4.   If the parameter file is kept on a UNIX machine, install DVOCmd on the UNIX machine and verify that DVOCmd has access to the parameter file.

5.   On the Advanced tab of a table pair or single table definition, specify the location and name of the parameter file.

6.   On the Advanced tab of a table pair or single table definition, specify the name, datatype, scale, and precision of each parameter.



Comments

  1. ANIL CHANDUFebruary 15, 2022 at 4:24 AM

    Could you please provide the some examples for parameter paths.

    ReplyDelete
  2. ANIL CHANDUFebruary 15, 2022 at 4:27 AM

    I have created the param file in windows and also in Unix, but I am getting file not found error.
    So could you please suggest me where can I place the param file.

    ReplyDelete

Post a Comment

Popular posts from this blog

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 Data Migration project is gathered and identified from the Testing perspective. QA is responsible for defining the scope of testing; high level estimation and Requirement Specification docs. This phase we will perform pre-migration testing, these tests occur
Read more

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: 1.
Read more

Differences between OLTP and OLAP

Online transaction processing system: *******************************   In OLTP system, the tables are in normalized structure As the OLTP is in normalized structure, DML operations like Updates and deletes will be faster Simple queries are run against the OLTP system OLTP system contains only current data. As the OLTP system does not contain history data, it cannot be used in reporting   Online analytic processing system: ****************************   In OLAP system, the tables are in de normalized structure   As the OLAP is in de normalized structure, the numbers of joins between tables are less and hence select statements will be faster   Complex queries are run against the OLAP system   OLTP system contains only history data and can be used for reporting purpose
Read more