Big queries for delete, insert and updates from SQL to Salesforce

Anonymous — Sat, 16 Nov 2024 04:02:26 GMT

Hi guys!

So I'm running a big query and it goes like this

SQLinput ---> tmap (lookups from order) ---> tmap2 (lookup orderitem id based on order id) ----> salesforce orderitem output (delete)

The problem here is i have 143,000 rows every night to process (new rows)

I figure I can do tmap lookups like i showed above, and then reload at each row for orderitem but then it will reload 143000 times which might take a really, really long time...and it might even error out and cause the whole job to fail

My question is, is there a better way to do this?

Is there a way to delete orderitems from an order in salesforce without having to lookup the orderitem id?

Need some advice! Thank you!

Re: Big queries for delete, insert and updates from SQL to Salesforce

Anonymous — Mon, 02 Dec 2019 07:29:13 GMT

Hi
As suggested by manodwhb in your another topic,
https://community.talend.com/t5/Design-and-Development/Dynamic-SQL-Input-queries-for-lookups/m-p/206694#M113315
had you tried to use globalMapkey in lookup query to filter the rows？

Regards
Shong

topic Big queries for delete, insert and updates from SQL to Salesforce in Talend Studio

Big queries for delete, insert and updates from SQL to Salesforce

Re: Big queries for delete, insert and updates from SQL to Salesforce