Using validation functions with the Validation transform

This recipe will demonstrate how validation functions are deployed and configured within a dataflow. As the validation function that we created in the previous recipe validates city values, we will deploy it in the DF_Extract_Address dataflow object to perform the validation of data extracted from the Address table located in the source OLTP database.

Getting ready

Open the job-containing dataflow, DF_Extract_Address, already created in the Use case example – populating dimension tables recipe in Chapter 5, Workflow – Controlling Execution Order, and copy it into a new job to be able to execute it as a standalone process.

How to do it…

  1. Open DF_Extract_Address in the main workspace for editing. ...

Get SAP Data Services 4.x Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.