topic Re: tmap join with multiple objects in Talend Studio

tmap join with multiple objects

Anonymous — Sat, 16 Nov 2024 12:19:04 GMT

Hi,
I have a input positional file which contains multiple fields. I need to use some of the fields from the file to query the salesforce objects and the resultset of the salesforce query needs to be fed to the tMap as a lookup. The positional file with be "main" connection and the outputs from all salesforce objects will be a lookup. The output of the tMap will be updating a Salesforce object.
However, when I right click on the salesforce objects and select "main" row to connect to the tMap, I am not allowed to do so. The connection line disappears (talend is not allowing to use the salesforce object outputs as lookup).
Can some one help me to acheive this? Please see the picture below. I have shown the whole job as the first picture and second picture mentions how I am querying the salesforce object. The other salesforce objects have similar queries and their schema are edited to match the SOQL queries.
The tJavaRow is used to assign the fields from the input file to context variables that can be used in salesforce object for querying.
Thanks,
Balaji.

Re: tmap join with multiple objects

Anonymous — Wed, 04 Apr 2012 10:28:31 GMT

Hi
You cannot use an output component for tMap join,Have the use input component

Re: tmap join with multiple objects

Anonymous — Wed, 04 Apr 2012 12:39:26 GMT

The salesforce components are input components only, not output component.
Thanks,
Balaji.

Re: tmap join with multiple objects

Anonymous — Wed, 04 Apr 2012 14:28:56 GMT

Hi
I can see the tSaleforceInput and tSaleforceOutput component in my talend.
Can you tell me which version u are using
I am able to join the tSaleforceInput with tMap as lookup

Re: tmap join with multiple objects

Anonymous — Fri, 11 May 2012 00:48:34 GMT

I was able to acheive this using the following setup.
tFileInputPositional ==> tFlowToIterate ==> tJavaFlex ==> tSalesforceInput ==> tMap.
However, the performance is a total killer in this case. To process just 100 records, it took more than 5 minutes. So, I ended up with a different design for the job.
Thanks,
Balaji.