Sometimes we need to validate field from list of values return from SQL query. ADF framework offers to built-in functionality for that.
Here I’m using Hr Schema’s Employees table.
- Select JobId Attribute in Employees entity and go to validation tab.
- Then click on “Green Plus” icon to add new validation rule on attribute.
- On Dialog window select
- Compare With=Query Result
- Write query to get all job id from jobs table.
SELECT JOB_ID FROM JOBS
- On Failure Handling tab set Error message.