#DateForumTypeThreadPost
2310 Apr 2014 @ 01:57 PDTTrainingTopicTPN+ membership : Teradata's ultimate training machineFolks - if ANYONE out there wants to join me in getting access to TPN+ membership reply or IM me ( preferably if there, IM in the forum that is ) . I have  been in Terdata world for a long tim...
2228 Oct 2013 @ 03:25 PDTDatabaseReplyPE and AMP setupHow do teradata determine the # of AMPS per node. Given a number of nodes - is there a thumb rule to get # amps ?
2109 Dec 2011 @ 09:10 PSTAnalyticsReplyIndex wizard is asking me to Knock of NUPI's created my other "index artists" .. Thanks Todd. I see - that point.  But there's nothing so much so that these were factors that'd affect the present query in any manner. This is what I had in mind - thanks for confi...
2007 Nov 2011 @ 08:36 PSTAnalyticsReplyIndex wizard is asking me to Knock of NUPI's created my other "index artists" .. Any takes ..? Dieter or any other knowledgable person . Indexes  lying around unused for  1  report might be getting used other places . So how can they impair performance in plac...
1907 Nov 2011 @ 04:23 PSTAnalyticsTopicTelling the optimizer to stop using Alias names In analysing explains - I noticed that the optimizer ( I am on 13.1x) is actually using table alias names  that are referred to in view and we have to delve into each view definition to fin...
1806 Nov 2011 @ 11:30 PSTAnalyticsTopicIndex wizard is asking me to Knock of NUPI's created my other "index artists" .. It was a complex Business Objects report with some > 30 joins and instead of coming up with some sort of Join Index recommendation I Wiz is asking me to drop a bunch of NUSI's that are...
1715 Mar 2011 @ 10:03 PDTAnalyticsReplywhat are my options in tuning this kind of query. In real life what worked best for youHi Dieter This is the developers artwork. Unless I get the business requirements of the query , I can only conjecture. From what I see, he is trying to Fastexport data using '|' as a separator, be...
1613 Mar 2011 @ 06:16 PDTAnalyticsReplywhat are my options in tuning this kind of query. In real life what worked best for youits a regular nested views structure so , in the explain "_t" refers to the corresponding view's base table.
1513 Mar 2011 @ 06:14 PDTAnalyticsReplywhat are my options in tuning this kind of query. In real life what worked best for youHi Dieter Thx It does have 2 LOJ's . The above explain refers to the following orignal query as below. EXPLAIN SELECT CAST( (CASE WHEN AL.ACCESS_INSTANT IS NOT NULL THEN TRIM(TRAILING '.' FRO...
1413 Mar 2011 @ 10:35 PDTAnalyticsReplywhat are my options in tuning this kind of query. In real life what worked best for youHi Dieter Thanks a bunch for your sharp answers. Here go the clarifications "Unless we run this extract at off peak hrs or ask other users to abort or borrow space from spool reserve, it sp...
1311 Mar 2011 @ 09:24 PSTAnalyticsTopicwhat are my options in tuning this kind of query. In real life what worked best for youI have a huge table with billions of rows and 3+ tb data being LOJ to another similar though lesser in size table. The pattern is something like Sel ..... ) and Tb4.C12 not in (...
1207 Oct 2010 @ 11:12 PDTDatabaseReplyHow to flatten / horizontalize multiple records in Teradata ....using recursion'knowledgeable folks'..you may ignore the above. I toiled out a solution and works just well.
1106 Oct 2010 @ 12:55 PDTDatabaseTopicHow to flatten / horizontalize multiple records in Teradata ....using recursionI know we can use a case info but what if the records are in millions..how do you flatten this using recursion in Teradata. Input sel accID /* this goes in millions */ , access level /*1 Acc...
1028 Feb 2010 @ 09:29 PSTDatabaseTopicthe clutter with explains .Just what is it and how to avoid that : Redistribution and DuplicationHi Folks I am still confused about just how this stuff , regards finding out whats happens in query explains , works. I kind of get the broad picture but am not really able to extract a precise...
918 Nov 2009 @ 05:48 PSTDatabaseReplyTD Express 12 won't start on fresh install[font=Arial Narrow]I had the same prob. I was running a 32 Bit XP on a 64 bit machine and I got the darn segmain error. Un Installed TD12 ( I could not do a clean un-install , I got rid of just the...
819 Dec 2008 @ 05:57 PSTDatabaseReplyany Acer for Stored Procs ? How to escape quotes in SP parameter. PL HELPHi rgswhat if the sp has parameters like call xyz ('p1','p2' ) only and p2 is a long string='blah=1 , blah2=2 , paramater1=('Merry Xmas'), parameter2="Somelse 'I'd like to pass the string as the p...
718 Dec 2008 @ 09:13 PSTDatabaseTopicany Acer for Stored Procs ? How to escape quotes in SP parameter. PL HELPHi Folks I created a Stored procedure that can take a string as a parameter.It all looks good EXCEPT for the part where the string contains commas and single quotes that must be escaped.<>...
611 Nov 2008 @ 05:10 PSTUDATopicMIGRATING PASSWORDS ACROSS DIFFERENT TERADATA DATABASESDOES ANYONE KNOW A WAY TO MIGRATE PASSWORDS ACROSS 2 DIFFERENT SYSTEMS.I have a bunch of users who want to be created with the old password. Any ideas here ....appreciated. ThanksSam
502 Nov 2008 @ 08:30 PSTDatabaseTopicTeradata MonitoringHi Folks We are Oracle folks undergoing corporate Teradata Training ( but it was not comprehensive enough ) and unlike Oracle , Teradata Monitoring is really a bit complex. I was monitoring the Sy...
423 Oct 2008 @ 04:45 PDTToolsTopicthe smart QueryMan for this Query !!! Convert Rows to ColumnsHi FolksI am preparing a tool and one of the consitituents is a very simple querySel accessright from dbc.allrolerights where The output will be CDERUI etcNow I want the output of the accessri...
318 Oct 2008 @ 07:12 PDTDatabaseReplyBTEQ inserts unwanted newlineRight .I probably looked at some real old stuff. Thanks Joe
217 Oct 2008 @ 07:34 PDTDatabaseReplyBTEQ inserts unwanted newlineThe latest version doc says max as 254 . is this not right ? can we increase it to 100000+
117 Oct 2008 @ 07:46 PDTDatabaseTopicBTEQ inserts unwanted newlineHi FolksI am automating the refresh of some view based, whose base tables have changed.The shell I run generates a DDL scriptsshow view $dbname$viewname ;the out put of this script has "create vie...