Loading data from table to table – lookups and joins

When you specify a relational source table in the dataflow, Data Services executes simple SQL SELECT statements in the background to fetch the data. If you want to, you can see the list of statements executed for each source table. In this recipe, we explore what happens under the hood when you add multiple source tables and how Data Services optimizes the extraction of the data from these source tables and even joins them together, executing complex SQL queries instead of multiple SELECT * FROM <table>.

How to do it…

In this recipe, we will extract a person's name, address, and phone number from the source OLTP database and populate a new stage table PERSON_DETAILS with this data set.

  1. Create a ...

Get SAP Data Services 4.x Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.