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

Exploring the Auto correct load option

The Auto correct load option is a convenient means Data Services provides for preventing the insertion of duplicates into your target table. This is the method of inserting data into a target table object inside the dataflow. It can easily be configured by setting the target table option to Yes, with no more configuration required. This recipe describes details regarding the usage of this load method.

Getting ready

For this recipe, we will create a new table in the STAGE database and populate it with a list of currencies from the DimCurrency dimension table in the AdventureWorks_DWH data warehouse.

Execute the following statements in SQL Server Management Studio:

SELECT CurrencyAlternateKey, CurrencyName INTO ...

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