Archives of the TeradataForum

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

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

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