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.
Lernen Sie, wie Sie / Learn how to
- 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.
Zielgruppe / Who should attend
SAS programmers who need to access data in Teradata from within SAS
Verfügbare Schulungsformen / Formats available | Dauer (kann variieren, Details s. Terminliste) | | |
Präsenzkurs: |
1 Tag | | |
|
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: Essentials course. You can gain knowledge of SAS from the SAS® Programmierung 1: Grundlagen course. A working knowledge of Teradata is helpful.
In diesem Kurs wird mit folgenden Software Modulen gearbeitet / This course addresses SAS/ACCESS, Base SAS Software
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
