Archives of the TeradataForum
Message Posted: Thu, 13 Mar 2003 @ 18:50:54 GMT
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
|