PowerCenter XML - Problem using Booleans

23 Dec 2013

I had an xs:boolean data type which remained unresponsive to 0, 1, false, true, "false", and "true" values.  In other words, the transformation was not evaluating these values correctly (or at all) in my XML parser transformation.

Data originated from a SOAP call, which had a related WSDL definition in a text file.

I manually changed (i.e. hacked) underlying WSDL to use xs:string - and then "true" and "false" started working as expected.

The unmodified WSDL in SoapUI did not show the same problem - it worked as expected with xs:boolean.

I was therefore unable to get any data out of a XML Parser transformation - which, ironically, had been created in PowerCenter by importing the very data I was not able to parse.  An obscure (to me) setting held the key.

See the “Advanced Options…” link below:

This controls how namespace labels are added (or not added) to XML tags. Setting this to “no” solved my problem - but I don’t know if there may be other unintended consequences down the line.