In this post we will discuss how to validate all mapping in a particular folder
Step1 : Go to the Repository manager client
Step2 :
Go to option Tools->Queries
Create a new query with name ALL_MAP_QUERY
Create a query with parameter name and condition to retrieve the mappings in a folder
as the following:
folder = folder-name
object type = mapping
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpXzQlAtxHtkOWT3KZo5T-DfcKVz8paCD1Pxt9gBUTOrQ78iS-uWd3xdd_syfEx0Azb4D8dhd__nY3TNZlFhgxOU5kc5E1bvNRUYzGihZUyagbMu9aTBjeUi8AEDDD8vvEdFg-UENxafdb/s400/Validate_Mapping.jpg)
Step 3:
a) Connect to power center repository using pmrep
pmrep connect -r RepositoryName -d DomainName -n UserId -x Passwd
b) Create a Persistent output file using command
pmrep executequery -q ALL_MAP_QUERY -u d:\infa8\PERS_OP_FILE
Step 4 :Use the persistent output file created in last step to validate mappings
pmrep validate -i d:\infa8\PERS_OP_FILE -u PERS_OP_FILE_LOG
Great Stuff
ReplyDeleteHi,
ReplyDeleteI did try this option, but it is not validating the mappings.In the final result the number of mapping that is invalid_before is equal to the number of mappings that are invalid_after. Any idea what could be the reason? Any permission related issue? I am able to successfully execute all the steps listed above.