#DateForumTypeThreadPost
2226 Jul 2014 @ 01:16 PDTConnectivityTopicUnable to connect to TD15 SQL AssistantI got the TD 15 installed using ' Teradata Tools and Utilities - Windows Installation Package' But i am getting the below error while connecting to SQL Assistant 'Unknown Error Oc...
2124 Feb 2013 @ 09:44 PSTPrivate Forum
2010 Mar 2011 @ 11:27 PSTDatabaseTopicPerformanceI have a query with around 60 joins , the first four joins are inner and the rest all are left outer joins. Can we improve the performance of the query by changing the order of the left outer j...
1905 Mar 2011 @ 11:00 PSTDatabaseTopicIO COUNTHi Whats the basic definition of IO count and cpu time,how are they related. Thanks and Regards Sree
1824 Dec 2010 @ 09:22 PSTDatabaseTopicJoining Sequencehi All I m using V12, Does the sequence of joins(outer) written in the query ,have any impact on the performance of the query. I had a query with around 60 joins ,with most of them left outer joi...
1702 Sep 2010 @ 11:37 PDTToolsReplyQuery performance in SQL and BTEQhi Tim thanks a lot.... do you meant CLI(client level interface)
1601 Sep 2010 @ 09:12 PDTToolsTopicQuery performance in SQL and BTEQHi all, What is the differenece between the query performance in SQL assistant and BTEQ.i observed a significant improvement in performance of a query in BTEQ compared to when run in SQL assistant...
1519 Jul 2010 @ 05:03 PDTToolsTopicfload and mload on empty tablewill the fload and mload take same time to load an empty table,wl there be any appreciable difference in load timing. Regards Sreehari
1419 Jul 2010 @ 12:48 PDTToolsReplyfastload insertion Thanks Jimm,yes it works in Mload but not in fastload,it shows "RDBMS error 3618: Expression not allowed in Fast Load ". Thanks Fein and Rob
1314 Jul 2010 @ 06:25 PDTToolsReplymloading of single table with multiple fileCarlos and robpaller THANKS
1213 Jul 2010 @ 05:54 PDTToolsTopicmloading of single table with multiple fileHi all, while mloading single table with multiple file,does teradata load these files parallely or one after the other. Regards
1111 Jul 2010 @ 05:01 PDTToolsTopicfastload insertion hi all, i am trying for a fastload inside a unix script,where in the table being inserted have six columns ,out of which three columns gets their data from flatfile,while the other three are date ...
1002 Dec 2009 @ 03:15 PSTAnalyticsTopicInternal Mechanism of RankingHi How does Teradata actually does the ranking internally.RegardsSreehari
929 Jul 2009 @ 06:15 PDTToolsTopicArchiving and PurgingHiWhere can i find information regarding Archiving and Purging in Teradata.ThanksSreehari
829 Jul 2009 @ 06:11 PDTToolsTopicDatamover ToolHiWhere can i find info(PDF) on Datamover Tool of Terdata.Can it be invoked from Teradata Demo Version just like the other utilities(Multiload etc)Thanks Sreehari
729 Jul 2009 @ 04:24 PDTToolsTopicDATA MOVER TOOLWhere can i find details about DATAMOVER TOOL in Teradata. Thanks
608 Jun 2009 @ 04:36 PDTDatabaseReplyprimary index hash valueHi Thanks for the info.........my understanding till now was that....all rows in an AMP will be identified by 32bit hash value+32 bit uniqueness vaue.....
504 Jun 2009 @ 05:56 PDTDatabaseTopicprimary index hash valueif 123 is a value of an unique primary index column of a particular table A,it will generate a particular hash value via hashing algorithm...now suppose a second Table B also has 123 in its unique ...
404 Jun 2009 @ 05:15 PDTDatabaseReplyRounding Down in TeradataHello,If possible please provide the query.
303 Jun 2009 @ 04:04 PDTDatabaseReplyRounding Down in Teradatacan u try thisselect cast(cast(0.96 as integer) as decimal(5,2))
230 May 2009 @ 09:50 PDTDatabaseTopicTeradata I/O'sHi AllOn what basis is the no of logical I/O's decided when a SQL is executed,and during a product join these I/O's increases........and the Node utilization goes up considerably........can somebo...
130 May 2009 @ 09:23 PDTDatabaseReplyAJI usage in SQLs which have subqueriesHi Annal,We also had similar issue with AJI's,i think AJI's will not be used if an subquery exists in the SQL.Thanks