validate deployment group: question

[kkp1225]

Hi,

I'm testing the step: Validate Deployment Group.

Validation Query: The name of the query to run to query the invalid objects of the deployment

Can you help understand this step or command ? Can you provide sample of this command or query which I can use it. Please let me know.

Thanks,
Kiran

[nhmathis]

Hi,

The Validation Query is used via the executequery pmrep command. This query is generated within Informatica. The plugin will then retrieve the query and execute it via the pmrep command.
Code: https://github.com/IBM-UrbanCode/Informatica-UCD/blob/master/src/main/scripts/validate_deployment.groovy#L57

The executequery command will return a file containing all objects that fit that query. The plugin step will continue and run the validate command against this list.
https://github.com/IBM-UrbanCode/Informatica-UCD/blob/master/src/main/scripts/validate_deployment.groovy#L163

If all objects defined by the query are validated, then the step will complete successfully.

More information can be found about the executequery and validate commands in the Informatica pmrep Documentation.

[kkp1225]

Thanks for the info.

I'm trying to understand this.
As an example: promoting from DEV to INT environment, The query has 10 objects in DEV.
If the executequery is done in DEV. It will get the list of 10 objects and outputs to a file.

executequery -q $query -u $queryOutputFileName

Then the next step to validate: It should validate the objects list file from DEV to INT...right..Looking at the validate, Im confused here.

validate -i $queryOutputFileName -s -k -m validated_$query -p saved -u $validationOutputFileName

In which environment does it validate ? In DEV or INT.

I don't see any parameters for getting connected to different host or server. If we need to compare the objects list from one environment to another. Then we need the validate step to be modify

Please review it and let me know.

Thanks,
Kiran