O'Reilly logo

SAP Data Services 4.x Cookbook by Ivan Shomnikov

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using database functions

There is no great variety of functions in this area. Data Services encourages you to communicate with database objects and control the flow of data within a dataflow.

How to do it…

You will learn a little more about the functions here.

key_generation()

First, let's look at the key_generation() function. This is the function the can be called only from the dataflow (when used in column mapping), so we are not interested in it at this point as we cannot use it in the Data Services scripts.

This function is actually similar to the Key_Generation transform object that can be used as part of a dataflow as well, and it is used to lookup the highest key value from a table column and generate the next one. This is often used to populate ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required