CALLING THE VALIDATION FUNCTION INTO VALIDATION TRANSFORMATION This Blog explains how to call a Validation function inside a Validation Transformation . Source table: EMP Description: we need to check for the Probation period based on the JOIN_DATE, Probation period is 6 months from JOIN_DATE to Current month, and if Probation period is completed for 6 months this can be moved to a Probation completed table else it needs to be moved to Probation_not_completed table. In this scenario we are validating the data from the database table by using Validation function instead of Column validation in Validation rules. Use Case: Validation function is used to Filter or Replace the source data set by writing script in Validation function under Custom function tab and call the same function in Validation transformation and produce desired output data set. STEP:1 Creating a Validation function which is used to validate the Probation Peri...