Scribd
Upload
8 views3 pages

Userguide 1924

The document outlines a PowerCenter script that utilizes pmrep commands for bulk validation of PowerCenter objects in a folder, specifically designed for versions 9.1 and 9.5. It details the input parameters required for the script execution and the types of objects that can be validated, along with the output results. A link to the solution and additional resources is also provided for further assistance.

Uploaded by

Aravind Ch
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
8 views3 pages

Userguide 1924

The document outlines a PowerCenter script that utilizes pmrep commands for bulk validation of PowerCenter objects in a folder, specifically designed for versions 9.1 and 9.5. It details the input parameters required for the script execution and the types of objects that can be validated, along with the output results. A link to the solution and additional resources is also provided for further assistance.

Uploaded by

Aravind Ch
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Name of Solution:

PowerCenter Script : Validate Folder Objects

Business Requirement:
PowerCenter scripts using pmrep commands to do bulk validation of PowerCenter objects in
a folder.

Solution URL:
https://community.informatica.com/solutions/1924

Supported Versions:
PowerCenter 9.1 and 9.5

Description:
During migration process it is common to have objects invalidated and performing the
validation through the client tools can be time consuming when the number of impacted
objects is large in number.

Another option is to use the command line utility pmrep's validate option to validate objects.

After the validation, the result summary of the command includes the number of valid
objects, invalid objects, and skipped objects.

You can validate the following types of objects :

Mappings,Mapplets,Sessions,Workflows,Worklet objects.

The script provided as a part of this block demonstrates how to validate all the workflows
and their dependent objects in a particular folder.

Following are the input parameters required in the listed order

- Domain Name
- User Name
- Password
- Repository Service
- Folder Name
The validation result is written into validate_script.log

Download file contents:


1. Script

Steps to implement the solution:


1. Ensure that you have INFA_HOME and INFA_DOMAINS_FILE environment variables
defined. Verify it as follow.

Please rate this solution and share your feedback on Marketplace Website.
2. The script takes following input parameters.
Input Parameters
$1 Domain Name
$2 User Name
$3 Password
$4 Repository Service
$5 Folder Name
3. Execute the command as shown below.

4. Observe the output as follows.

YouTube Video on Importing and Configuring Workflows:


http://www.youtube.com/playlist?list=PLLRreK2jjjgWBQ4NPfp0QWTxYDvlnEqSJ

Please rate this solution and share your feedback on Marketplace Website.
Other Useful links:

Mapping Bundles
Workflow Bundles
Informatica Tools Bundles
Informatica for Social Media Bundles
Debugging Tools Bundles
Visio Templates Bundles
B2B Templates and Projects Bundles
Data Quality Packs and Plans Bundles
Script Bundles

Please rate this solution and share your feedback on Marketplace Website.

You might also like