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 ...

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.