DSXchange

hi,

i have following scenario:

database----extract---File
File---Put---- MQ

All the data put to queue as single message, by configuring sequential file.

here the queue has limit of 4 mb, i can get a scenario where data is greater than 4mb. In that case i have to split it in say 1000 records / file using row num function in transformer. But how can i configure how many files required or is this approach correct.

Please guide me.

From your description it isn't quite clear what you are doing. Do you have 1 row with over 4Mb, or a group of rows totalling over 4Mb?

...All the data put to queue as single message...

, then

...split it in say 1000 records / file...