Archives of the TeradataForum

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

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

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>>