Loading XML message to MQ Queue
Posted: Wed Aug 27, 2008 4:21 am
I created a job to load XML soap message to the queue.
I am extracting data from the table by using Oracle Stage, Using Transformer Stage I am defaulting value for few columns that are not coming from the source table. I have used XML Output stage to convert it to XML message per row. I have used MQ stage to load these XML soap message to MQ. Input rows are 6 in my source table and needs to be loaded as 6 XML soap message to the queue. But the output of the job is loading message per column instead of record (row).
Appreciate greatly any help on this.
I am extracting data from the table by using Oracle Stage, Using Transformer Stage I am defaulting value for few columns that are not coming from the source table. I have used XML Output stage to convert it to XML message per row. I have used MQ stage to load these XML soap message to MQ. Input rows are 6 in my source table and needs to be loaded as 6 XML soap message to the queue. But the output of the job is loading message per column instead of record (row).
Appreciate greatly any help on this.