This course teaches you how to read Teradata tables in Teradata using the SAS 9.4 SAS/ACCESS Interface to Teradata. You learn how to connect to Teradata and to query a single Teradata table and multiple Teradata tables. You also learn efficiency techniques and options for optimizing data access performance.
Изучается
- read Teradata tables using the LIBNAME statement and the SQL pass-through facility
- use options and efficiency techniques for optimizing data access performance
- join data using the SQL procedure and the DATA step
- publish and use SAS formats in Teradata.
Аудитория
SAS programmers who need to access data in Teradata from within SAS
Before attending this course, you should be comfortable programming in SAS and Structured Query Language (SQL). You can gain this experience from the SAS SQL 1:Основы course. You can gain knowledge of SAS from the Программирование на языке SAS, Часть 1. Основы course. A working knowledge of Teradata is helpful.
Используется SAS/ACCESS, Base SAS ПО
Introduction- course logistics
- overview of SAS/ACCESS software
- overview of Teradata
- connecting to Teradata
Using the SQL Pass-Through Facility - connecting to Teradata and investigating Teradata metadata
- creating SQL pass-through queries
Using the SAS/ACCESS LBNAME Engine- using the LIBNAME statement for Teradata
- using data set options
- creating views
- combining tables
Performance Considerations- improving performance with the LIBNAME statement
Base SAS In-Database Technology- overview of SAS In-database technology
- using Base SAS procedures in Teradata
- using SAS formats and user-defined formats in Teradata
Learning More
Appendix (Self-Study)- Introducing Teradata Parallel Transporter Application Programming Interface
- loading data with FastLoad and MultiLoad
