Effectively Moving SAS Data into Teradata
Global Business Intelligence and Data Integration Practice
Effectively Moving SAS Data into Teradata
Document Type: Best Practice Date: February 1, 2010
Contact Information Name: Jeffrey D. Bailey Title: Database Technical Architect Phone Number: (919) 531-6675 E-mail address: Jeff.Bailey@
Revision History
Version 1.0 2.0
By Jeffrey D. Bailey Jeffrey D. Bailey
Date July 11, 2008 Feb 1, 2010
Description
Initial Version Removed Confidential Information Added a case study Added performance statistics
Table of Contents
1 Introduction .............................................................. 1
1.1 Purpose of the Paper .......................................................................... 1 1.2 Target Audience .................................................................................. 1 1.3 Overview .............................................................................................. 1 1.4 Business Problem(s) Addressed ....................................................... 1 1.5 Technical Problem(s) Addressed ...................................................... 2 1.6 Environment Requirements ............................................................... 2
2 Connecting to Teradata (Review) ........................... 3
2.1 Verify that you can connect to Teradata Using SAS ........................ 3 2.2 Connecting to Teradata Using SAS? Foundation............................. 7
3 Creating Teradata Tables? A Word of Warning .... 8
3.1 Teradata Parallelism ? By Design ...................................................... 8 3.2 Primary Indexes .................................................................................. 8 3.3 Why Is This a Problem with SAS ....................................................... 9 3.4 Specify the Primary Index Using SAS ............................................. 12
4 Teradata FastLoad and MultiLoad Utilities.......... 13
4.1 SQL Insert Statements...................................................................... 13 4.2 The Teradata FastLoad Utility .......................................................... 18 4.3 Loading Data Using the FastLoad Utility ........................................ 20 4.4 The Teradata MultiLoad Utility ......................................................... 21 4.5 Loading Data Using the MultiLoad Utility ....................................... 22
5 Loading SAS Data Into Teradata (FastLoad) ....... 26
5.1 FastLoad Protocol Restrictions ....................................................... 26 5.2 SAS Bulkloading Using Teradata FastLoad.................................... 27
6 Loading SAS Data into Teradata (MultiLoad) ...... 37
6.1 MultiLoad Protocol Restrictions ...................................................... 37 6.2 Configuring SAS for MultiLoad ........................................................ 38
7 A Real Case Study ................................................. 64
8 Bibliography ........................................................... 68
9 Credits and Acknowledgements .......................... 69
BEST PRACTICE FOR EFFECTIVELY LOADING SAS DATA INTO TERADATA
1 Introduction
1.1 Purpose of the Paper
Teradata is one of the most robust and best performing relational database management systems (RDBMS) available. Its performance with huge volumes of data is amazing. Some of that data will definitely come from SAS. But, what is the best way to move that SAS data into the Teradata server? This paper will explore that question. Fortunately, SAS is able to use the Teradata utilities that make loading Teradata tables from SAS fast and easy.
1.2 Target Audience
The target audience for this paper is SAS Intelligence Platform administrators, SAS programmers, and consultants who need to move SAS data into Teradata.
1.3 Overview
Efficiently loading Teradata from SAS is not very difficult, it certainly isnt magic, but you need to be aware of some traps. We will cover the various loading methods available and help you decide which of these methods best meets your needs. We will:
Learn about the Teradata supplied load functionality ? FastLoad and MultiLoad. Learn how to leverage the Teradata FastLoad protocol from within SAS. Learn how to leverage the Teradata MultiLoad protocol from within SAS. Learn to avoid adding entries to the Teradata Journal Table. Learn which Teradata objects will prohibit you from using Teradata load protocols.
1.4 Business Problem(s) Addressed
The business problem is straight forward. We have large amounts of data that we need to move into Teradata. We want to load this data as efficiently as possible. This paper will provide you with options on how to do this effectively.
1
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- description remarks and examples stata
- effectively moving sas data into teradata
- excellent ways of exporting sas data to excel
- working with dates and times stata
- mxdatetime date time library for python
- date timestamp guidelines
- how to calculate unix time using a pic18 mcu and the
- copyright © tutorialspoint
- timedate time and date utilities
Related searches
- download stock data into excel
- pull pdf data into excel
- sas data analysis
- change sas data type to character
- importing stock data into excel
- downloading stock data into excel
- reading sas dataset into sas
- sas data step variable order
- how to input data into r
- how to read data into r
- loading data into r
- read data into r