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
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
- 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.
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.