SAP BODS – Validation - Part Four
In this session, as a simple example, we are going to create a new Project and its subcomponents in Data Services Designer, to extract data from an Excel file, load the data to various targets based on a validation.
Validation transform is used to filter or replace the source dataset based on validation rules to produce desired output dataset. This transform is used for NULL checking for mandatory fields, Pattern matching, existence of value in reference table, validate data type, etc.