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 passing it from Map_Operation to the next transform. Map_Operation assigns one of the four statuses to each record passing through: normal, insert, update, or delete. By default, the majority of transforms in Data Services produce records with a normal...