Reports window 322, 634
selecting a perspective 323
reverse impact analysis 312, 317
rows
adding 430
closing out in datetime change tracking
556
matching and updating 431
removing all 429
running jobs 147
S
SAS Application Servers 6, 27
SAS code
displaying for jobs 160
SAS Data Integration Studio
documentation 9
environment and 5
starting 20
SAS data servers 7
SAS Grid Server 6
SAS Intelligence Platform
documentation 9
SAS invocation options
setting on jobs 303
SAS Management Console
environment and 5
SAS Metadata Bridges 66
exporting metadata 75
importing new metadata 68
importing updated metadata 70
preparing to import or export 67
usage notes for 66
SAS Metadata Server 6
connecting to 22
reconnecting to 24
SAS names 88
SAS OLAP Server 6
SAS Package
importing and exporting metadata 60,
62, 63
preparing to import or export metadata
61
SAS Package wizards 641
SAS start commands
modifying for application servers 269
SAS Workspace Server 6
SAS/CONNECT Server 6
SAS/SHARE Server 7
SCD
See slowly changing dimensions (SCD)
SCD Type 2 Loader transformation 422,
523
scheduling
deploying jobs for 227
for complex process flows 235
prerequisites for deploying jobs 227
redeploying jobs for 233
to execute jobs on remote host 236
Section 508 10
security 19
SELECT clause
configuring 459
SELECT statement
optimizing 487
servers 6
slowly changing dimensions (SCD) 522
closing out rows in datetime change
tracking 556
dimension tables 524
fact tables 527
loading dimension tables with Type 1
and 2 updates 535
loading fact tables with dimension table
lookup 545
loading tables and adding surrogate
primary key 551
project stages 524
star schema loading process 524
star schemas and 522
tracking changes in source datetime
values 554
transformations supporting 523
types of 523
Sort transformation 435
creating tables containing sorted
contents of a source 438
sort transformations 435
optimizing sort performance 435
sort-merge joins 481
sorting
performance and 435, 438
pre-sorting data 480
source code
jobs with generated source code 146
jobs with user-supplied source code
147
source tables
mapping columns to work table 276
sources
table containing sorted contents of 438
SPD Server 7
SPD Server cluster tables 577
creating 578
maintaining 579
SPD Server Dynamic Cluster folder 41
SPD Server star joins 478
SPD Server Table Loader transformation
422
special characters
in table and column names 88
790 Index

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.