parameterize To run queries

[lmit]

Hi all,

We have a requirement like

We have set of 8 queries which needs to run for few countries but for one country I need to generate 4 queries and for other country I need to run 5 queries and for other all 8

I want to parameterize the run of a queries based on the number and which query to run

Can anyone suggest how to achieve it

Thanks in adavance,
Lmit

[Anonymous]

Hi,

    I would say create a superset of queries to be executed in one job. Then you will have to store the list of queries which need to be executed for each country in a configuration table.

   So once you get the query, go to this config table and get the corresponding values as boolean for each query. Then using if condition, you can determine whether to go to that block or not.

   I think its is the most easy way to handle this situation.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂