SAS Data Integration Studio 4.9

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