Question Limit number of rows in a mapping

Bonjour,
I have a mapping from a DB to a JSON webservice. I would like to only load 100 rows at a time, but I cannot figure out how to do this? Is there a filter that can do this?

Thanks!

Hi,

In a Mapping a target WebService is invoked for each value of the repetition key.
So if you have 1000 source rows, the target WebService will be called 1000 time sequentially.

Can you give a little more detail on what you want to accomplish ?
If you want the Mapping to load only 100 rows, you could filter the source

We have product data in Semarchy and need to export that to Netsuite via JSON WS. Our ultimate goal is to do this as fast as possible. In the past, simply running the mapping as is with not filters on the entire data set took days to complete. I was hoping to run the mapping multiple times in parallel to increase the throughput. Is there a better way to increase the performance?

How would I create a filter on the source? I only see a way to filter at the attribute level. Please be specific in your answer and be aware because of the fact I am in the US there are time zone differences.

Thanks for the help.

Let's close this thread. I'm working with Shahin.
I know how to query to get N records and then submit them via web services calls in M batches. Basically it's just a SQL Operation bound to the execution of a Delivery.

But I'll open a new thread with a more precise question about an issue I'm seeing with running these sessions in parallel.

Thanks Matt, indeed making batches of rows is usually done with SQL.
For your information, we plan to improve our WS features so that one can specify parallelization params.