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
Multiple records to one - MQ
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 40
- Joined: Tue Oct 14, 2008 3:30 pm
- Location: London
You can use the vertical pivot of the enterprise pivot stage at V8 to convert multiple input rows into one output row for MQ.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 8
- Joined: Tue Sep 01, 2009 6:16 am
Re: Multiple records to one - MQ
Hi
Set the MQ stage properties
MessagingWriteMode = "Create"
RecordCount=0
RowBufferCount=-1
Set the MQ stage properties
MessagingWriteMode = "Create"
RecordCount=0
RowBufferCount=-1