SAS 9.1.3 ETL Studio: Users Guide

interactive 43

z/OS 183

data analysis 12

data cleansing 12, 24

data marts

creating 25

data quality transformation templates 12, 51

data services 11

data sets

password-protected 185

data stores

specifying metadata for 60

updating metadata in jobs 118

viewing metadata in jobs 118

data transfers 12

data validation 24

data warehouses 24

cleansing data 24

creating data marts 25

creating dimensional data 25

denormalizing source data 24

designing 23

example 27

extracting source data 24

libraries for 44

loading data 24

planning 25

security plan for 26

software requirements 39

validating data 24

database servers

login for authentication domains 185

DB2

table access with ODBC DB2 z/OS pass through 184

DBMS

verifying output when updating 183

DBMS column names

case and special characters 50

DBMS libraries 46

DBMS names

schema names and 180

DBMS table names

case and special characters 50

DBMS tables

case and special characters 183

dropping 181

metadata for tables with keys 66

re-creating 181

Update Table Metadata and 183

default SAS application server 42

code generation and 43

impact of 43

interactive data access 43

selecting 59

denormalizing source data 24

desktop 14

dimensional data 25