SAP Data Services 4.x Cookbook

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