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

[Anonymous]

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!

[Anonymous]

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/206...
had you tried to use globalMapkey in lookup query to filter the rows？

Regards
Shong