 |
 |
Archives of the TeradataForum
Message Posted: Fri, 21 Dec 2007 @ 10:44:01 GMT
| Subj: | | Re: Teradata Views looking at Tables in a different |
| |
| From: | | McCall, Glenn David |
| | > I am wondering if Teradata has a facility to create views which look at tables in a different RDBMS? | |
| | Directly, no, but it is possible to do this by writing an External Table UDF. | |
| | Another consideration is performance. Every time you access such a table function, it must: | |
| | 1) Establish a connection to the remote system | |
| | 3) Transfer the results (over the LAN) to Teradata for inclusion in the query referencing the table function | |
| | 4) Terminate the session. | |
Ooops, I said "... a table function ... must ... [do those 4 things]". A minor correction is in order. Obviously, I meant a table function
that connects to and extracts data from another system has to do the 4 things listed above. Another table function might not do any of those 4
things. An example might be a test data generator that generates rows at random - which could generate large volumes of data very quickly!
Glenn Mc
P.S. Seasons greeting to all
| |
