Multiple records to one - MQ

[senthil_tcs]

Hi,

We have a requirement to load set of records (Specific category code) as a single message into MQ. Can someone help me how to implement this? I know there is a option in XML transformer to do this and taking the key column whenever the value changes it will create a new XML message,so I am not sure how we can do the same for pipe delimited text file and load the same to MQ. Currently if I load the data to MQ if we have 20,000 records with the same category code it loads as 20,000 messages. So I believe some logic needs to be implemented before loading the data to MQ. Any help much appreciated.

Thanks,
Senthil

[ArndW]

You can use the vertical pivot of the enterprise pivot stage at V8 to convert multiple input rows into one output row for MQ.

[padmavathi]

Hi

Set the MQ stage properties
MessagingWriteMode = "Create"
RecordCount=0
RowBufferCount=-1