Monday, February 18, 2013

XML Generator pass-through ports

I'm using XML Generator transformation to create XML using a number of input ports. I'd also like to use an audit table that would contain all input ports along with the generated XML. You can't link however expression ports used to create XML with XML Generator output. XML Generator is an active transformation and will give the "Concatenation disallowed..." error message:
To achieve that you need to send the input ports through the XML Generator. Here's what needs to be done. The below adhrers to XML Parser as well.

To create a pass-through port in a midstream XML transformation:

  1. Edit the XML Transformation and open the Midstream XML Generator (or Parser) tab (the last one)
    The DataOutput or DataInput port appears (depending on the transformation type)
  2. Add needed additional output ports and define appropiate data types
  3. Click XML Editor button:
  4. In the XML Editor right-click the XML definition and choose Add a Reference Port
  5. Select all required ports and click OK
  6. Save the changes and close the editor. In the transformation you should now see the pass-through ports available:
Now it's possible to send everything downstream in one flow.

No comments:

Post a Comment