Optimizing dataflow execution – the SQL transform

Simply put, the SQL transform allows you to specify SQL statements directly inside the dataflow to extract source data instead of using imported source table objects. Technically, it has nothing to do with optimizing the performance of ETL as it is not a generally recommended practice to substitute the source table objects with the SQL transform containing hard-coded SELECT SQL statements.

How to do it…

  1. Take the dataflow used in the previous recipe and select Validation | Display Optimized SQL… to see the query pushed down to the database level. We are going to use this query to configure our SQL transform object, which will substitute all source table objects on the left-hand side of the dataflow. ...

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.