Filtering data to component

Anonymous — Sat, 16 Nov 2024 05:27:18 GMT

Hi,

I have a job that is retrieving data from Salesforce and making an insert into another SF table based on the results of the first query.

Using tSalesforceOutputBulkExec, I see that even if no data are sent for the insert, the connection is still open to Salesforce (I can see it from the bulk query monitoring). I would like to avoid the opening of the connection if no results are found in the first query. Here below a screen of my job:

How could I set the job to continue with the tSalesforceOutputBulkExec only if there are data to transfer? Is there any way to do it directly in the tMap component, or maybe by filtering in some way the 'main'?

Thanks
Iris

Re: Filtering data to component

manodwhb — Thu, 27 Jun 2019 11:24:39 GMT

@altibzz , As i understand that you need to insert if there is data in file to insert into slaesforce right. You need to use the below way.

Re: Filtering data to component

Anonymous — Thu, 27 Jun 2019 12:32:44 GMT

in this way I am still opening the bulk connection, am i right? Thanks

topic Re: Filtering data to component in Talend Studio

Filtering data to component

Re: Filtering data to component

Re: Filtering data to component