I am fetching some records (approx. 10 in count) using stored procedure and I need to validate these records one by one.
Here is the requirement regarding validating these records.
FirstName, Last Name and Email
2. Following Validation to Be applied on all these 3 fields
Once each of these records passes these validations then we need to process these records one by one.
Records which don't pass these validations need to be logged in separate table and mail will be send for them.
Is it possible to apply these validations on the records using Talend ODI? If yes please help me with this.