Hi, I am new to Talend. Can someone explain me the steps involved in passing a dynamic variable to a query using talend. From step 1 to step N if possible. I am not able to do so. I basically want to use a date pulled out from one table and use that in a query. The query should be able to dynamically carry the variable value as the date may change in the parent table. Please help TIA
Easy to do: 2 ways to do: use context variables or the globalMap (only accessible within the job). 1. create a context variable (e.g. country as String type) 2. add the database component to your job and add the query (at first with a fix value) "select ID, sum(revenue) from country_rev where country_name='USA'" 3. now change the query to use your variable: "select ID, sum(revenue) from country_rev where country_name='" + context.country + "'" 4. If you have your value in the globalMap here is the necessary query: "select ID, sum(revenue) from country_rev where country_name='" + globalMap.get("country") + "'" Talend only supports plain text replacements for the query in input components. You can also consider using the *row components, these comps supports prepared statement parameters.