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 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.

Start your free trial