Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 21 Dec 2007 @ 10:44:01 GMT


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


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  


  2) Run a query  


  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



     
  <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: 15 Jun 2023