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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.