I'm doing a basic SFDC select and then upserting the data into a Postgres database. I've been running into some performance issues and have been trying to experiment with batching to speed things up. I followed the guide here:
As expected, only a single list document (containing multiple 'rows') is returned from the initial query. I edited the XML profile to include the extra List element (as seen in the guide). But when I feed that list document into a map, only a single row comes out and gets written to Postgres. So, I guess the question is, how can I feed a single document with multiple records into a map and have that map spit out multiple mapped records? Right now, if 100,000 rows are returned from Salesforce, only one row gets written to Postgres. I need all 100,000 rows to be written.
Thanks for any input!