How to build query parameters dynamically rather defining them well ahead in the “Execute Query” activity,
Lets assume a query with parameters as such in a file called “employee_query.sql”,
select * from employee e where e.deptId = ? and e.startdate >= ? and e.enddate < ?
reading the above query from a file whose filepath is defined in config file.
All I want to understand is how can I dynamically create the parameters rather defining it in the “Execute Query” activity.
Can someone share your thoughts please to solve this issue.