SAP Data Services 4.x Cookbook

Using the Map_Operation transform

Here we explore a very interesting transformation available to you in Data Services. In fact, it does not perform any transformation of data per se. What it does is that it changes the type of the SQL Data Modification Language (DML) operation that should be applied to the row when it reaches the target object. As you probably know already, the DML operations in SQL language are the operations which modify the data, in other words, the INSERT, UPDATE, and DELETE statements.

First we will see the effect Map_Operation has when used in a dataflow, and then we will explain in detail how it works. In a few words, the Map_Operation transform allows you to choose what Data Services will do with the migrated row when ...