Database Reference
In-Depth Information
Export/Import
You can perform the
Export
/
Import
functionality from the PowerCenter Designer or the
Workflow Manager screen. Whenever you export the components, Informatica creates the
.XML
file for those components. Similarly, you can import the components if they are
available as
.XML
files. So, any export/import operation will happen in the
.XML
format.
You can view the file in the XML editor and, in fact, change the file before you import it.
The code will be imported with the changes you made in the file. Ideally, you should not
change the exported file to avoid consistency issues across different environments.
To complete the migration, you export the components from one repository and import in
another repository. A similar approach can be used to migrate code from one folder to an-
other folder in the same repository.
Migrating from the designer
Before we proceed, note that we can migrate only those components that are present on the
the PowerCenter Designer screen. To migrate the components, perform the following steps:
1. Open the designer and from the navigator, select the component you wish to mi-
grate and navigate to
Repository
|
Export Objects
. We selected a
m_UNION
map-
ping for our reference in this topic, as shown in the following screenshot. When
you export the mapping, corresponding sources, targets, and transformations get
exported. Similarly, when you export the workflow from Workflow Manager, all
the tasks present in the workflow gets exported. So, you need not export all com-
ponents separately.
We are exporting the components from the
learnwell
folder.
