Hi All, I'm new to talend and have a complex functionality to be build. I want to query some tables from Salesforce(Account, Contact, CustomObject1, Opportunity, CustomObject2). 1. An Account may have multiple contacts. 2. CustomObject1 Has a lookup to account and may have multiple Opportunities as well as multiple CustomObject2 records) need to query the data of all these objects where the opp.stageName = 'closed won'. And then need to insert all the data into 5 SQL tables. Assuming that i would need to have 3 queries( 1. on Opportunity fetching the opp/Account/CustomObject1 data, 2. On Contact to extract contacts of the queried accounts 3. On customObject2 to get records based on CustomObject1 as the parentId) I want to have the flow in a way that 1. For each CustomObject1 : Insert 1 customObject1 record 2. then insert all CustomObject2 records 3. Then insert other child records. Stuck with how to iterate and combine the tmaps.
