I have some validations like date format, string length and alphanumeric check that I need to apply on certain fields in multiple jobs. I don't want to use tMap filter expression for that because that will not provide me the exact reason due to which the record is rejected.
I there any way to achieve this in Talend ?
tFilterRow (with basic or advanced settings) may help for that in most cases.
You may also use tJavaRow.
In this case consider to add a field in the output flow in which you'll indicate the reject code if any.
Then you'll be able to filter (tFilterRow again) rows to be rejected.
Also, if you want to centralize the validation code, consider to use routines.
Hope this helps.
Watch the recorded webinar!
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.
Practical steps to developing your data integration strategy.