SAS Data Integration Studio 4.9

registering with Register Tables wizards

81

reviewing and modifying, in queries

445

setting default name options 91

source tables 276

SPD Server cluster tables 577

specifying options for 86

target tables 276

temporary output tables 306

updating metadata with physical table

85

work tables 276

Tables Report

customizing 324

target tables

adding columns to 455

mapping columns from work table 276

temporary output tables 150

preserving 307

redirecting 307

reviewing 306

viewing 307

testing code 128

threaded reads 487

Tools-Options window 634

tracking

datetime change tracking 554, 556

transformation options 269

transformation properties window 632

transformations 32

actions based on status of 217

adding directly to iterative jobs 507

Change Data Capture 557

Data Transfer 158

DB2 Bulk Table Loader 422, 426

displaying generated code for 268

editing generated code for 286

for lookups 300

for message queues 569

for star schemas 300

generated 277, 284, 316

Join 443

Key Effective Date 524

limiting input 302

List Cluster Contents 580

List Data 308

loader transformations 421

Lookup 523

Oracle Bulk Table Loader 422, 425

Remove Cluster 580

replacing generated code for 287

SCD Type 2 Loader 422, 523

Sort transformations 435

SPD Server Table Loader 422

status handling for 209

submitting selected transformations 167

supporting slowly changing dimensions

523

Surrogate Key Generator 524

Table Loader 422, 424

User Written Code 274, 308

verifying output 302

viewing code for 195

Websphere Queue Reader 571, 572

Websphere Queue Writer 570, 571

Transformations tree 32

tree view 635

troubleshooting unsuccessful jobs 175

Type 1 updates 527, 535

Type 2 updates 535

U

undoing checkouts 51

Ungrouped folder 43

unique keys

adding 107

key columns 104

update table metadata feature 85

updates

Type 1 527, 535

Type 2 535

User Written Code transformation

adding to process flows 308

user-defined formats 28

user-supplied source code 147

user-written code 271

adding to Precode and Postcode tab 272

editing generated code for jobs or

transformations 286

generated transformations and 277

macro variables for status handling in

224

maintaining generated transformations

284

replacing generated code for jobs or

transformations 287

SQL 452, 488

User-Written Code transformation

adding to jobs 274

user-written external files

registering 128

V

validating data 297

View Data window 637

creating tables 117

View File window 638

views

managing for performance 294

792 Index