Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 04 Mar 2004 @ 10:34:54 GMT


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


Subj:   SPSS+Teradata
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, March 03, 2004 23:29 -->

We are using SPSS Clementine with our Teradata Warehouse but are now facing with an issue.

According to SPSS Clementine, their queries against the Teradata Database will be Optimised only when we SELECT data from a single Database. If the User runs a query which involves a JOIN for tables in multiple Databases, their query becomes a Drag on Teradata System.

To overcome this, we now need to copy 900 View DDLs from many Databases to a new single database and use that for SPSS Clementine Access. This is frustrating and raises redundany issues. Does anyone know of tools such as these which like picking up data from a single Database and suggested workarounds.


Cheers



     
  <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: 27 Dec 2016