topic Re: Dynamic SQL Input queries for lookups in Talend Studio

Dynamic SQL Input queries for lookups

Anonymous — Sat, 16 Nov 2024 04:09:56 GMT

Hi!

First I want to say thank you for always helping me out, this community is very responsive and helpful!

I want to know if it's possible to create dynamic lookup queries for each row from main input query

Let's say i have this structure:

Salesforce INPUT (lookup)

SQLInput (5 rows) > tmap > salesforceOUTPUT

for the Salesforce INPUT lookup, i want to set the query to only select based on a value for each row from the SQLinput.

That way it doens't have to select all the records then do a lookup which can slow things down

Thank you!!

Re: Dynamic SQL Input queries for lookups

manodwhb — Thu, 07 Nov 2019 05:44:48 GMT

@Zykros , You may try with reload for each row option in tmap to get the specific record lookup.

Re: Dynamic SQL Input queries for lookups

Anonymous — Thu, 07 Nov 2019 07:16:04 GMT

@manodwhb, I think Zykros don't want to load all lookup records in memory if the volume of data set is very big. He want to add a condition on tSalesforceInput to select only the records based on a value from the current row. right? @Zykros.

Re: Dynamic SQL Input queries for lookups

manodwhb — Thu, 07 Nov 2019 07:24:51 GMT

@shong and @Zykros , i believe we can call globalMapkey in tSalesfoce input query which we set in in tmap.so that it will extract the required data for each row .

Re: Dynamic SQL Input queries for lookups

Anonymous — Fri, 08 Nov 2019 03:25:01 GMT

thank you @manodwhb and @shong !!