Archives of the TeradataForum
Message Posted: Thu, 04 Mar 2004 @ 10:34:54 GMT
<-- 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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|