 |
 |
Archives of the TeradataForum
Message Posted: Mon, 08 Nov 2004 @ 15:42:07 GMT
| Subj: | | Re: SAS dataset access |
| |
| From: | | Fred Easey |
Brian,
We do a lot of querying Teradata through SAS and IMO you're best off doing what Fred Keiser recommended and fastloading the SAS dataset into
Teradata and doing the join Teradata to Teradata.
Joining Teradata to SAS through ODBC is a *bad* idea.
Alternatively, if you're pushed for space in your Teradata environment, pull the required Teradata data into SAS and do a proc SQL there. This
should take a lot longer to process though, as SAS isn't as efficeient as Teradata in running large SQL queries.
Fred Easey
| |
