Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 19 Aug 2004 @ 15:00:13 GMT

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

Subj:   Re: Connecting Oracle to Teradata real-time
From:   Yonina Schuchman

We "connect" various Oracle databases to Teradata using the Oracle Transparent Gateway for Teradata.

We set up a database link in Oracle that points to the Oracle Gateway server which in turn points to Teradata. We created views in Oracle on top of the Teradata objects we wish to query. These views cannot be joined to Oracle tables without causing performance problems.

From time to time we run into problems when joining these linked views together. If there is not enough filtering in the query, Oracle will try to bring all the Teradata rows across the network and do the joining on the Oracle server. We resolve this by creating a prejoined view in Teradata and one Oracle linked view referencing this.

We have been using the Oracle Transparent Gateway for over five years now and are satisfied with the current performance of our Gateway applications.

Yonina Schuchman
Charming Shoppes, Inc.

  <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