Hi,
Trying to parse database varchar column as XML document, here what I did
1. in tMap, convert string column to Document by calling ParseUtils.parseTo_Document(xmlString)
2. in tXMLMap, use metadata xml defintion and map the xml elements/attributes to output columns.
The job compiles OK. but the columns all come out null. I try the same xml as file, the tFileInputXML parse the column correctly.
Am I missing any step?
I am using TOS 4.2.1