Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 13 Mar 2003 @ 18:50:54 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: FastExport Benchmarking
From:   Fred Keiser

Is there a reason you are not accessing Teradata from SAS? Using SAS/ACCESS for Teradata is extremely efficient. You can libname Teradata implicitely or explicitely. You can PROC SQL with pass-thru to Teradata or use DATASTEP against a Teradata table. If you are extracting from Teradata to a SAS dataset for SAS processing, the above approach is more efficient. Constructing the right SQL will put most of the work on Teradata and it's multiple processors verses bringing the data back to UNIX and have SAS use one processor.

Fred Keiser
HCIRA/Decision Support Systems

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020