#DateForumTypeThreadPost
3310 Aug 2013 @ 10:50 PDTDatabaseTopicIssue with Rank/row_number in tableHi    I have a table with 19 M records and we are using row_number to get ranks on 10/11 cols. Something like:   row_number () over (partition by cola,colb,colc,cold  order ...
3220 Jan 2012 @ 02:58 PSTTrainingTopicRegd TD 12/13 Certification Hi, I had cleared the first level TD certification (Basics) for V2R5 and was given the Teradata Certified Professional certificate . That was in 2008. Now I want to clear my next level o...
3108 Jun 2011 @ 10:23 PDTDatabaseTopicGrouping sets in TD13HI, Currently we are using thinking of using grouping sets in TD12 to reduce the no.of inserts that we are doing in our table aggregating data at different levels.Now that our database would be ...
3029 Apr 2011 @ 03:32 PDTDatabaseTopicWay to transpose columns to rows?Hi, Is there any way of transposing data from cols to rows without using multiple insert statements or multiple select with union all? Thanks.
2914 Apr 2011 @ 11:49 PDTDatabaseTopicNot updating correctlyHi , I have field "child_cd" of VARCHAR(5). It has values like W14,W15 etc. I wanted to increase the count by 1..i.e wanted to make it W15,W16 etc. But then I noticed that the update qry did...
2826 Nov 2010 @ 04:02 PSTDatabaseTopicError during fast exportHi, I am trying to write 15M records into a file using fast export. But it throws the following error : RDBMS failure: 2644, No more room in database c0000 where c0000 is the username. ...
2707 Sep 2010 @ 02:23 PDTDatabaseTopicHow to use rank in update stmtHi, I have a requirement where I need to populate different fields that would hold individual ranks for different products/categories. I didn't want to use different update stmts for it rather...
2620 Jul 2010 @ 10:07 PDTDatabaseTopicPool size?Hi, Is there anything called max and min pool size in Teradata? Is this information available any where? Thanks.
2512 Jul 2010 @ 06:49 PDTDatabaseTopicGenerating dynamic queriesHi, We have a requirement where we need to extract some (common) fields from a table for different dates based on regions. For eg : If it is US, then we need to get data for (say 1st Jan,2010) ...
2404 Jul 2010 @ 03:26 PDTDatabaseReplyProblem getting sample records using "top"Thanks! I guessed so. We were apprehensive using SAMPLE considering that our table had around 20M records.
2301 Jul 2010 @ 11:34 PDTDatabaseReplyProblem getting sample records using "top"Thanks for the reply. But what if we don't have the privilege to increase the spool space. The DBAs are reluctant to do so. Is there any work around?
2201 Jul 2010 @ 03:03 PDTDatabaseTopicProblem getting sample records using "top"Hi, We were trying to get a sample of 200K records. Initially we were testing if we could get those samples using "top". But it threw a spool space error. Later on we got those samples using ra...
2123 Jun 2010 @ 05:29 PDTDatabaseTopicHow to get the amount of data?Hi, Is there a way to find the amount of data present in a partition in teradata?
2015 Jun 2010 @ 12:03 PDTDatabaseTopicDB link equivalent in TeradataHi, I believe there is no concept of DBLINK in Teradata. But what I wanted to know is if there is an efficient way of loading data from 1 table present in 1 database into another. These databas...
1914 Jun 2010 @ 04:48 PDTDatabaseReplyHow to get the list of procedures?Thanks! :)
1814 Jun 2010 @ 02:21 PDTDatabaseTopicHow to get the list of procedures?Hi, Is there a way in which we can get the list of stored procedures present in database ( the way we can get the list of tables) ? TIA.
1705 Feb 2010 @ 06:40 PSTAnalyticsTopicConvert columns to rows.Hi ,I have a table with data like :US 110 120 130UK 50 60 70I want data to be :US 110US 120US 130UK 50UK 60UK 70The reason i want to bring all values into a single column is that I can use rank fn...
1603 Feb 2010 @ 12:40 PSTAnalyticsTopicGetting the sum without using the columns in group byHi,We have a requirement where we need to show the total sum as well as sum grouped based on levels :eg: If there are 3000 orders , 1400 is under level 1 and 1600 under level 2, then data should be...
1501 Feb 2010 @ 01:03 PSTAnalyticsTopicQuartile fnHi,We have a requirement where we have to show top regions based on quartile calculations. So if for example we have 48 regions, we would display 12th,24th,36th region. The no. of regions an change...
1404 Oct 2009 @ 11:27 PDTAnalyticsTopicStoring multiple values in a columnHello,I want to store multiple values in a column so that when i use it in IN clause all values are picked up in it as separate entities..What I mean from above is that: Suppose I have a table T1 w...
1314 Jul 2009 @ 07:58 PDTUDATopicUsing replace in TDHi,Is there any way to simulate the oracle's replace function in TD (other than using the UDF oreplace)?I am facing problem using this:app_user.oreplace(content_name,'|',' ')Whenever i try using t...
1208 Jul 2009 @ 09:12 PDTAnalyticsTopicQuestion on calendar weekHi,In sys_calendar.calendar the weeks start from sunday and end on saturday.But I have a requirement where the weeks should start on monday and end on sunday (irrespective of the year).Which means ...
1112 Jun 2009 @ 06:06 PDTUDATopicAssigning week number with weekending on Sundays..I have a requirement where in i have to assign weeknumbers starting from 1.The weeks would end on Sundays.This needs to be done for year 2009.But the 1st day of 2009 didn't start on monday.So if we...
1024 May 2009 @ 10:50 PDTUDAReplyPerformance issue with the queryThank u all!
919 May 2009 @ 01:59 PDTUDAReplyConcatenating different values in a field...Thank you! it works perfectly..

Pages