Dear Experts
We are producing XML files as target out puts.
How to get the record count of XML file using DataStage ?
Thanks
Number of records in XML
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
You are using version 8 so you can turn on operational metadata and collect row counts for every stage in your job - including the number of rows sent to your XML output stage. This would match the XML record count if you were writing relational records out in a simple repeating XML format.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Ditto to everything above.....another thing to consider is to not let the XMLOutput Stage do the actual i/o ....if the xml documents aren't extrememely large, put an output link on the xmlOutput Stage with a single column....called it something like "myXMLoutput" with a longvarchar datatype and some long length....send "that" row to disk with a downstream Seq stage or other. Then you will get two row counts ---- the rows going into xml, and the "chunks" or "documents" of xml that are coming out. In many situations people aggregate the whole thing and it's just "1" document as a result, but if you are doing something fancy with triggers and such, you'll get an accurate count of "n" xml documents or chunks.
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am