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

Creating a target data object

A target data object is the object to which we send the data within a dataflow. There are a few different types of target data objects, but the two main ones are tables and flat files. In this recipe, we will take a look at a target table object.

Note

Views imported into a datastore cannot be target objects within a dataflow. They can only be a source of data.

Getting ready

To prepare for this recipe, we need to create a table in our STAGE database. To do that, please connect to SQL Server Management Studio and create the Person table in the STAGE database using the following command:

CREATE TABLE dbo.Person
(
  FirstName varchar(50),
  LastName varchar(50),
  Age integer
);

This table will be used as a target table, which we ...

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