Repository Guide

10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5.1
- 10.5
- 10.4.0

Back Next

Exporting Objects

When you export an object, the

PowerCenter Client

writes the definition of the object to an XML file. The XML file complies with powrmart.dtd and uses the same code page as the repository from which it was exported. After you export objects, you can modify the XML file.

To exclude the password parameter from the XML file when you export an object, set the INFA_SKIP_SENSITIVE_DATA environment flag to yes. The INFA_SKIP_SENSITIVE_DATA flag is valid for source metadata imported from PowerExchange in the PowerCenter Designer. After you set the flag, you must either modify each existing object individually or create new objects.

If you fail to modify the objects in the

PowerCenter Client

or create new objects before exporting using the

PowerCenter Client

or pmrep
, the password appears in the exported XML file.

When you export the latest version of an object, the

PowerCenter Client

exports either the version of the object saved in the repository or the version of the object you have open in the Designer or Workflow Manager:

Version saved in the repository.
When you export an object from the Repository Manager, pmrep
, or the query results accessed from the Repository Manager, the

PowerCenter Client

exports the version of the object saved in the repository.

Version you have open in the Designer or Workflow Manager.
When you export an object from the Designer, Workflow Manager, or query results accessed from the Designer or Workflow Manager, the

PowerCenter Client

exports the latest version of the object, including any change you made to it since you last saved it to the repository.

However, when you export shortcuts from the query results accessed from the Designer, the Designer exports either the version of the referenced object you have open in the Designer or the version of referenced object saved in the repository, depending on the other objects you export.

For example, you run an object query from the Designer. The query result contains the following objects:

Shortcut_to_Source1 in the Orders folder. The shortcut references Source1 in the Items folder.

Source1 in the Items folder

Mapping1 in the Items folder

Target1 in the Sales folder

The Designer behavior depends on the other objects you export:

Exported Objects	Designer Export Behavior
Shortcut_to_Source1 from the Orders folder Target1 from the Sales folder	Designer exports the saved version of Source1 because you do not export any object from the same folder that contains the referenced object, Source1.
Shortcut_to_Source1 from the Orders folder Mapping1 from the Items folder	Designer exports the version of Source1 you have open in the Designer because you export an object, Mapping1, from the same folder that contains the referenced object, Source1. Therefore, the Designer exports the latest versions of all objects in the Items folder, including changes you made to them since you last saved the repository.