Dynamically pass values from transformer to xml stage

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
Murali4u
Participant
Posts: 37
Joined: Sun Feb 21, 2010 12:27 pm

Dynamically pass values from transformer to xml stage

Post by Murali4u »

All,

I have a requirement to pass a value from transformer stage (one of the column say 'Dummy' which has distinct values) and i need to assign this value to the xml file name in xml write stage instead of static name.

So whenever there is a distinct value encounter, the corresponding xml should have the dummy column value as file name.

Pls let me know if any one has some idea on this. Thanks in advance.
Rockzz Tech
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

one possibility is to use the trigger column and allow the xml stage to write multiple files with a suffix that it generates dynamically (to keep the files unique, assuming that you are creating more than one in a single stream), and then post process the set of xml files with another DS job, or another process, to rename them as desired.
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
Post Reply