Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 02 Jul 2010 @ 19:01:51 GMT


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


Subj:   Re: Experiences with Teradata & Ms sql server
 
From:   Mark.Lerner

The only issue we've run into is using OLAP services under MS SQLServer to build Analysis cubes (in SQLServer Analysis Service) from Teradata direct connections. MS doesn't tune their SQL generator for Teradata. You can't control the SQL that gets generated (or I haven't been able to figure out how) and it invariably wants to do SELECT DISTINCT instead of GROUP BY in building cube dimensions. Obviously, this can become a real problem with large tables. We had to build special "dimension builder" views with embedded GROUP BY's for MS to use to work around the issue.



     
  <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