All forum activity

#DateUserForumTypeThreadPost
4047115 Apr 2014 @ 11:50 PDTn_shashiDatabaseReplyPartition Primary IndexThanks for the responses. Hi Adeel,  I'm not sure where to start with. I know the theory regarding PPI. However, when it comes for realtime implementation, I'm not sure where to star...
4047015 Apr 2014 @ 11:36 PDTAdeel ChaudhryGeneralReplyNo Spool space errorWhat are the demographics of these tables .... e.g unique values per column? No more spool-space error occurs when it is running out of space on 1 AMP, so the way you write the SQL also matter. &n...
4046915 Apr 2014 @ 11:33 PDTAdeel ChaudhryDatabaseReplyImplementing system generated keysWell, for one .... youo dont need to generate it yourself. But it is better to generate it within your process .... SQL or though ETL tool. It gives you more control on data and can change/fix valu...
4046815 Apr 2014 @ 11:01 PDTramnathjkDatabaseTopicOptimizer confidence level and understanding explain planHi Guys,   I have a doubt regarding the confidence levels of the optimizer in the explain plan.   Below is the scenario that i created: 1. Created 2 tables Location and Employee with...
4046715 Apr 2014 @ 02:47 PDTbmaniGeneralTopicNo Spool space errorHi,           I have two tables (both tables have 4 integer columns) one table with 70k records and other with 1.1 million records. I need to join both of them without any...
4046615 Apr 2014 @ 02:45 PDTislandermanToolsReplyfastload error message: Not enough fields in vartext data record number: 1So the older teradata DBD interface, 'DBD::Teradata' was able to do Fastload and MLoad, but not 'DBD::ODBC' ? I am not familiar enough with JAVA, so I would need to run this either...
4046515 Apr 2014 @ 02:15 PDTvhariConnectivityReplyDBD::ODBC Connects from command line, not thru crontabCheck the odbc.ini ($ODBCINI) file and see what is directory is assigned to "InstallDir" entry under [ODBC] section.  And verify, the DataDirect ODBC DM message files odbc.m & od...
4046415 Apr 2014 @ 01:55 PDTrraghuram64DatabaseTopicImplementing system generated keysHi..   Could some one tell me the positive impact of implementing system generated keys via use of identity columns?
4046315 Apr 2014 @ 01:04 PDTwenjinToolsTopicwhere to download the installation for Teradata Schema WorkbenchDo you know where to download the installation for Teradata Schema Workbench? Thank you!  
4046215 Apr 2014 @ 12:53 PDTQaisar Aftab KianiDatabaseReplyPartition Primary IndexCouple of things I would add, Adding the PPI doesn't guarantee the improvement in execution time until and unless they are being used properly in most of the queries. So basically you need to a...
4046115 Apr 2014 @ 12:48 PDTQaisar Aftab KianiDatabaseReplyFallback technique in TeradataYou can make the tables fallback using ALTER table statement, and can take a lot of time depending on the records in the tables as the opertaion is a full-table scan. The system reads all the rows ...
4046015 Apr 2014 @ 12:29 PDTQaisar Aftab KianiDatabaseReplySkew FactorRead the above post by ulrich. In short yes, if you want to reduce the skeweness you need to check which columns or combination of columns provide better distribution.
4045915 Apr 2014 @ 12:09 PDTTnewbeeThird Party SoftwareTopicBi tool cannot read from different databases in teradata?Hi, We have some BI queries which run on Teradata. Now these queries create a temp table in the base tables database and then read from another transaction table again in the base tables daabase. ...
4045815 Apr 2014 @ 10:35 PDTSivakumar.thotaViewpointTopicSpool Alert on Viewpoint 14.10Hi,  I am trying to create an alert to monitor spool usage at the session level.  I want to send an alert only when any session uses 5 TB spool for 30 mins. I don't see any option to...
4045715 Apr 2014 @ 10:26 PDTislandermanToolsTopicTTU Installation on Linux RedHatCan anyone tell me how I can get hold of the TTU download for Linux RedHat?  I've seen a few posts for requests but the only answers I've seen is pointing to documentation about the in...
4045615 Apr 2014 @ 09:35 PDTToddAWalterDatabaseReplyWhich is efficient?Spool will remain the same, execution cost after the initial table reads will be the same. Overall performance of the query will not be the same because the underlying table has to be read in order...
4045515 Apr 2014 @ 08:52 PDTAdeel ChaudhryConnectivityReplyApplication not started because all AMPs are in NewProc or Fatal StateCan you shed some light on your setup of Teradata? Systems, versions, etc.?
4045415 Apr 2014 @ 08:52 PDTAdeel ChaudhryToolsReplyBTEQ - Parametrize output FileYou can't do that using TTUs. Yet you can achieve the same results using a little coding in any language .... to give an interface to get variables and replace & execute the scripts.
4045315 Apr 2014 @ 08:47 PDTggoConnectivityReplyTPT TeraData Parallel Transporter API (x64) and Visual Studio 2012ok, it seems that the components are built with Visual C++ 2005 on windows, so I guess I have already already been lucky that it works with vs2008. There is probably at least one major differ...
4045215 Apr 2014 @ 08:44 PDTtaj786DatabaseReplySkew Factorhi i am new to teradata,  HOW REDUCE SKEW FACTOR IF IT IS >60 . IN TABLE I HAVE NUPI, SHALL I GO FOR COMBINATION OF COLUMN AS PI TO CHECK SKEW FACTOR . WHAT ARE OTHER APPROACH TO REDUCE SK...
4045115 Apr 2014 @ 07:23 PDTHarpreet SinghDatabaseReplyWhich is efficient?and spool will remain same also?  in TD14.
4045015 Apr 2014 @ 07:19 PDTHarpreet SinghDatabaseReplyWhich is efficient?Does it mean that Tables can have any number of columns and this will not impact performance as long as select is retrieving few columns? select a1,a2,b3 from A join B on A.a1=B.b1 --A has 200 co...
4044915 Apr 2014 @ 06:49 PDTaneelkumar04ToolsTopicTPT10508: RDBMS error 2583 error in teradata tptHi, I am trying to insert data from prod to dev by using TPT Update operator. By mistake i have deleted all error tables including work table, log table. Agin when i submit the script am got TPT1...
4044815 Apr 2014 @ 06:27 PDTdnoethDatabaseReplyConvert integer to TIMEHow is the time stored within the INT?  hhmissssssss?
4044715 Apr 2014 @ 06:24 PDTdnoethAnalyticsReplyREGEXP_SPLIT_TO_TABLE doesn't work Hi Raja, i don't know about 14.10, but in 14 the initial one was too close to 00.00 and quite buggy version :) There's 14.10.01.01 available which is approx. 5 month later than the 14.10....

Pages