Moving data from one repository to another repository

How to move the data from development repository to testing repository:

Exporting File from development repository:

Ø Open the Informatica Power Center Client Designer.
Ø First Login to development repository by entering the Username, Password, Host name and Port number.
Ø Now Login to testing repository by entering the Username, Password, Host name and Port number.
Ø Now we have both repositories in repository navigator.
Ø Click on development repository mapping folder, then right click on the folder(Mapping)
Ø Click on open option from right click menu (Then mapping will be opened in mapping designer)
Ø Now select Export option from right click menu
Ø It will ask you to save the file (Then give the path in the browser where you want to export this file. It is .xml extension file.)
Ø Once you save it, it will display output, errors (if any), warnings (if any)
Ø Now click on close.

Well. Now you have successfully exported the file.

Import File from local folder to Test repository:

Ø From Informatica Power Center Client Designer menu bar select repository, in this menu you could find import objects option.
Ø Click on this option.
Ø It will display wizard to browse the object file, browse the file, which you have exported from development repository.
Ø Now click next button
Ø Add source, target, mapping objects to be imported to test repository
Ø Again click on next button.
Ø Finally click finish button.
Now the file will be imported to test repository.

Similarly Workflows will be moved from Development repository to Test repository in the workflow designer.

This is the same procedure to move the data from Testing repository to Production repository.

This is one way to move the data from one repository to another repository…
We can follow other methods also… Very soon I’ll update this blogger with other methods…
Please leave your comments….