Very small gibberish output from XML XSL transformation

[JRodriguez]

Hi Kelly,

"Divide and conquer" will be the best approach on the cases that are failing. Try to parse the XML input file that is failing without applying the XSLT step, just output the content of your XML into another XML file. If it fail then you have the root cause. Just make a copy of your original DS job, remove the XLST spreed sheet and dump the content into another file

Try to apply the transformation within DataStage unless there are special transformation in your XSLT that can not be done in DataStage

Finally, try using the new Hierarchical stage instead of the legacy XML Transformer stage... The latter is more robust and is like an ETL tool by itself

Hope it help, regards

[eostic]

Another question (and potential alternative) also would be "how nasty is the .csv" that you are creating (?), and what was the reason for using xslt? Generally speaking, that Stage was put in place to support complex xml to xml kinds of transformation activity........

Not that the xslt is the issue, but it doesn't get the exercise that other Stages get, and is more difficult to debug.

I am sure you have a valid use case, but it might be worth exploring to see if you could simply the process and use xmlInput instead and have it output the .csv directly, or else just shred the xml and let some other parts of DataStage output the .csv....

Ernie