As per requirement I want to read a marker value from a file and pass that value as parameter in select SQL of a JDBC reader to pull only delta records. Is this possible in 13.9.1 version? Please advise with documentation link if available.
Solved
Pass parameter as filter condition in JDBC reader sql
- Data Enthusiast
- 8 replies
Best answer by AKislyakov
Hi
The best way to implement such logic is to use SQL Select step instead of JDBC Reader step. SQL Select allows parameterization of the query and executes it ones by each incoming row. So, your plan should look like following: Text File Reader step to read the marker value and then SQL Select to read incremental data from a database. You can find an example of it in the Tutorials project, the “06.11 SQL Select” plan.
- Ataccamer
- 149 replies
- Answer
Hi
The best way to implement such logic is to use SQL Select step instead of JDBC Reader step. SQL Select allows parameterization of the query and executes it ones by each incoming row. So, your plan should look like following: Text File Reader step to read the marker value and then SQL Select to read incremental data from a database. You can find an example of it in the Tutorials project, the “06.11 SQL Select” plan.
Reply
Most Liked this week
Login to the Ataccama Community
No account yet? Create an account
For Ataccama Customers and Partners
or
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.