PowerCenter - Xml Target

Card Puncher Data Processing

About

Powercenter Xml Target

To import and edit the XML target

If the workspace contains targets, you can clear them with a right-click on the workspace.

  • Click Targets > Import XML Definition.
  • Navigate and select the xsd file. Click Open.

The XML Definition Wizard appears.

  • Name the XML definition as you want and click Next.
  • Select Skip Create XML Views, and click Finish.

The XML Wizard creates the target with no columns or groups.

  • Double-click the XML definition to open the PowerCenter - Xml Editor.
  • Click XMLViews > Create XML View.
  • From the XPath Navigator, drag the columns into the empty XML view.
  • In the xml view, right-click a column, and choose Set as Primary Key, create relationship if needed

Powercenter Xml Relationship Pk

  • Click File > Apply Changes and close the XML Editor.





Discover More
Card Puncher Data Processing
PowerCenter - Xml

XML is a common means of exchanging data on the web. Use XML files as a source of data and as a target for transformed data. The designer represents an XML hierarchy in an XML definition as a set of views....



Share this page:
Follow us:
Task Runner