xml o/p aggregation using DS ver 7.5

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Output mode needs to be 'Use trigger column' if you want a change in value of that field to drive filename changes in the output.
-craig

"You can never have too many knives" -- Logan Nine Fingers
deeps
Participant
Posts: 6
Joined: Tue May 02, 2006 9:38 am
Location: india

Post by deeps »

chulett wrote:Output mode needs to be 'Use trigger column' if you want a change in value of that field to drive filename changes in the output. ...


Thanks for your inputs.
Tried using this option but in this case some of the tags could repeat:

<directory>
<customer name="Acme" zone="East">
<division>Toys</division>
<city>Boston</city>
<city>New York </city>
</customer>
</directory>

whereas what I am looking for is an output like:

<directory>
<customer name="Acme" zone="East">
<division>Toys</division>
[b<city>New York </city>[/b]</customer>
<customer name="Acme" zone="East">
<division>Toys</division>
<city>Boston</city></customer>
</directory>
considering that zone content triggers/changes to change the o/p rows accordingly.

Is that possible using xml?
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Clearly no. What file name could be generated if the file name were to be based on a repeating element?!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

You have no control over how it builds multiple filenames, other than supplying the 'base' name. It will then, from the second file generated onwards, append an '_?' number to that.

The trigger column controls when the current file is closed and a new one opened. Where you put the Key column is what controls the repeating element.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply