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. Could you please provide the some examples for parameter paths.

    ReplyDelete
  2. 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

Informatica DVO

ETL Testing