DSXchange

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

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

Hi

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