Table of Contents

Search

  1. Preface
  2. XML Concepts
  3. Using XML with PowerCenter
  4. Working with XML Sources
  5. Using the XML Editor
  6. Working with XML Targets
  7. XML Source Qualifier Transformation
  8. Midstream XML Transformations
  9. XML Datatype Reference
  10. XPath Query Functions Reference

XML Guide

XML Guide

Connecting Target Ports

Connecting Target Ports

You need to correctly connect XML target ports in a mapping so the Integration Service can create a valid XML file during a session. When you save or validate a mapping with an XML target, the Designer validates the target port connections.
Use the following guidelines when you connect ports in a mapping:
  • If you connect one port in a group, you must connect both the foreign key and primary key ports for the group.
  • If you connect a foreign key port in a group, you must connect the associated primary key port in the other group. If you do not connect the primary key port of the root group, you do not need to connect the associated foreign key ports in the other groups.
  • If you use an XML schema with a default attribute value, you must connect the attribute port to create the default attribute in the target. If you pass a null value through the connected port, the Integration Service writes the default value to the target.

0 COMMENTS

We’d like to hear from you!