For my process I am simply doing a query on the database for inventory in the below format. I then need to save these results as a csv file. It is a 153,893 rows. The problem I have with this process is the mapping, doing a direct map from a database profile to an identical csv profile takes 7 minutes. The query takes less than 30 seconds and then the mapping takes 7 minutes. I don't think it really should need a map, assuming there is functionality to do this sort of thing.
I'm even considering doing something like a find and replace on the data to accomplish this, as it seems like it would be a much quicker way to accomplish the same thing, though I don't know how to do that in boomi either.
If anyone knows a way to speed up a simple mapping like this or a way to avoid the map all together, please let me know.
id, sku, upc, actual_qty, unallocated_qty