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

Chapter 4. Dataflow – Extract, Transform, and Load

In this chapter we will take a look at examples of the most important processing unit in Data Services—the dataflow object—and the most useful types of transformations you can use inside them. We will cover:

  • Creating a source data object
  • Creating a target data object
  • Loading data into a flat file
  • Loading data from a flat file
  • Loading data from table to table – lookups and joins
  • Using the Map_Operation transform
  • Using the Table_Comparison transform
  • Exploring the Auto correct load option
  • Splitting the flow of data with the Case transform
  • Monitoring and analyzing dataflow execution

Introduction

In this chapter we move to the most important component of the ETL design in Data Services: the dataflow object. The ...

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