Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 10 Aug 2000 @ 13:09:29 GMT


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


Subj:   Re: SOS! Teradata and Business Objects
 
From:   Dave Sedgwick

Thanks for that Dave, the answer is similar to what you've described. The reason it was spooling was actually an object in the universe that was using the original table name not the aliased name. It did not reveal itself in the universe as clicking on the table that has been aliased and selecting 'view associated objects' revealed nothing - an interesting feature. If a designer does create an alias table and performs this check they would assume all objects have been correctly changed to use the alias name. Obviously as the aliased table is not joined to anything it was doing a 1=1 product join between two sizeable tables.

Right, that's one cracked, next one is figuring out the union part of the report query...

Dave



     
  <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