Informatica 7.1 : How to validate all mappings in a reposirory in one shot

Problem :
We are to upgrade INFA7.1 to INFA8.1.The most common problem is after upgrading many mappings just become invalid which remains valid before upgradation.We faced that problem while exporting-importing also.
So our first concern is to find out
i/
which mappings becomes invalid after upgradation
ii/
Sort out them.Fix them.
iii/
Restore them.

But the first task iteself is tough as we have almost 700 mappings on run.So its tedious and cumbersome if we are to check them manually one by one.

Solution:
I have automated the whole process of cheking which will tell you which mapping are invalid after parsing them.

Process:
i/
INFA has its own repository in which it keeps all records,status about all mappings.
At first we are to find out from the metadata level which mappings are of which status.
So we will creat a wrapper unix shell ( main_map_check_hasim_v1.sh ) in which we will call a sql script having the following sql code.

select 'validate -n '||parent_mapping_name||' -o mapping -f '||parent_subject_area||' -p valid,invalid_before,invalid_after -b' from rep_all_mappings where order by parent_subject_area

ii/
we will take all the output in one spool file which will be the feeder for the main unix script ( pmrep_map_check_hasim_v1.sh ).

iii/
making that mappingcheckhasim_v1.sh excecutable.

iv/
invoke pmrep-->connect-->call that mappingcheckhasim_v1.sh with appropriate parameters.

connect -r repositoryname -n repositoryuser -x repositorypassword -h repositoryhostname -o repositorportno

run -f validchekhasimrun.sh -o validoutput.txt
run -f invalidchekhasimrun.sh -o invalidoutput.txt

v/
Exit from pmrep,look for the output file which has been created by pmrep.grep it for 'invalid' entities,create file for those invalid mappings,send it to prospective users.

Enhancement:

i/
Help developers giving them the reson for invalid mappings.
ii/
Help developers assisting them to validate it.
iii/
Help developers assisting them to save it.
iv/
Help developers assisting them to check-in it with proper message.
---: My blog is not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m_a_hasim@yahoo.com