XML Guide

10.4.0
- 10.5

Back Next

Editing XML Target Definition Properties

After you create an XML target definition, you can edit the properties to reflect changes in the target data, add business names and comments, or change the code page.

To edit XML target definition properties:

Open the XML target in the Target Designer.

Right-click and select Edit.

On the Table tab, edit the settings.

The following table describes the Table settings:

Table Settings	Description
Select Table	Name of the target definition. To change the name, click the Rename button.
Business Name	Descriptive name for the target table. Edit the Business Name using the Rename button.
Constraints	Not applicable to XML targets. Any entry is ignored.
Creation Options	Not applicable to XML targets. Any entry is ignored.
Description	Description of target table. Character limit is 2,000 bytes/K, where K is the maximum number of bytes for each character in the repository code page. Enter links to business documentation.
Code Page	Select the code page to use in the target definition.
Database Type	Indicates that the target definition is an XML target.
Keywords	Use keywords to organize and identify targets. Keywords might include developer names, mappings, or XML schema names. Use keywords to perform searches in the Repository Manager.

On the Columns tab, you can view XML column definitions.

The following table describes the Columns settings:

Columns Settings	Description
Select Table	Displays the target definition you are editing. To choose a different definition to edit, select one from the list of definitions you have available in the workspace.
Column Name	Name of the column.
Datatype	PowerCenter datatype for the column.
Precision	Size of column. You can change precision for some datatypes, such as string.
Scale	Maximum number of digits after the decimal point for numeric values.
Not Null	Indicates if the column can have null values.
Key Type	Type of key the XML Wizard generates to link the views.
XPath	Path through the XML file hierarchy that locates an item.

On the Properties tab, you can modify the transformation attributes of the target definition.

If you use a source-based commit session or Transaction Control transformation with the XML target, you can define how you want to flush data to the target.

The following table describes the attributes that you can edit:

Columns Settings	Description
Select Table	Displays the source definition you are editing. To choose a different source definition to edit, select the source definition from the list.
Duplicate Group Row Handling	Choose one of these options to handle processing duplicate rows in the target: First Row . The Integration Service passes the first duplicate row to the target. Rows following with the same primary key are rejected. Last Row . The Integration Service passes the last duplicate row to the target. Error . The Integration Service passes the first row to the target. Rows with duplicate primary keys increment the error count. The session fails when the error count reaches the error threshold.
DTD Reference	DTD or XML schema file name for the target XML file. The Integration Service adds the document type declaration to the XML file when you create the XML file.
On Commit	The Integration Service can generate multiple XML files or append to one XML file after a commit. Use one of the following options: Ignore Commit. The Integration Service creates an XML file and writes to the XML file at end of file. Create New Document. Creates a new XML file at each commit. Append to Document. Writes to the same XML file after each commit.
Cache Directory	Directory for the XML target cache files. Default is the $PMCacheDir service process variable.
Cache Size	Total size in bytes for the XML target cache. Default is auto.

On the Metadata Extensions tab, you can create, modify, delete, and promote non-reusable metadata extensions, and update their values. You can also update the values of reusable metadata extensions.

Click OK.

Click Repository > Save.

Working with XML Targets

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal