Setting the Implicit Property for a Join . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 482
Problem . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 482
Solution . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 482
Enabling Explicit Pass-Through Processing for SQL Join Transformations . . . . 484
Problem . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 484
Solution . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 484
Tasks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 484
Using Properties Window Options to Optimize SQL Processing Performance . . 486
Problem . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 486
Solution . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 486
Tasks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 486
About Join Transformations
Overview
The SQL folder in the Transformation tree contains a number of transformations that
enable you to add SQL processing to jobs. This chapter is about the Join transformation.
The Join transformation provides an interface for building the statements and clauses
that constitute queries. The transformation supports the SAS SQL procedure syntax of
Create table/view <table> as <query expression> and accommodates
up to 256 tables in a single query. The SELECT statement supports joining the table to
itself. It also supports subqueries; the CASE expression; and WHERE, GROUP BY,
HAVING, and ORDER BY clauses.
The process of building the SQL query is performed in the Designer window. You
access this window when you double-click the Join transformation in a SAS Data
Integration Studio job. You use the Designer window to create, edit, and review an SQL
query. The window contains sections that are designed to simplify creating the SQL
query and configuring its parts. To return to the SQL job on the Designer tab of the Job
Editor window, click Up on the toolbar.
The Join transformation supports the pushdown feature that enables you to process
relational database tables directly on the appropriate relational database server. For
information about pushdown, see “Pushing ELT Job Code Down to a Database” on page
198.
See the SQL-related usage notes in “General Usage Notes” on page 645. For
information about other SQL transformations, see “Working with Other SQL
Transformations” on page 489.
Using the Designer Window
Problem
You want to create SQL queries that you can use in SAS Data Integration Studio jobs.
You want to build these queries in a graphical interface that enables you to drag and
drop components onto a visual representation of a query. After a component is added to
the query, you need the ability to open and configure it.
Using the Designer Window 443

Get SAS Data Integration Studio 4.9 now with O’Reilly online learning.

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