#DateForumTypeThreadPost
1827 Jun 2015 @ 04:47 PDTDatabaseReplyhow to find version of a teradata database?can you please elaborate on this ? is there any criteria for deletion or random no of rows can be  deleted
1727 Jun 2015 @ 04:43 PDTDatabaseReplyColumn MaskingCan you elaborate ? You want encode the values of columns ?
1627 Jun 2015 @ 04:41 PDTDatabaseReplyTeradata Express database instance - why no Windows versionthat is problem my sytem is 32 bit and RAM is only 3 gb
1526 Jun 2015 @ 08:34 PDTDatabaseReplyTeradata Express database instance - why no Windows versionbut thing is running vmware image  make windwos very slow .
1426 Jun 2015 @ 09:50 PDTDatabaseReplyTeradata Express database instance - why no Windows versionCan we get Linux version ?
1326 Jun 2015 @ 09:40 PDTDatabaseReplyMdb Access to TeradataThere are two way in which you can load data from mdb file to TD 1. Conver mdb to csv and then use tpt 2. OLE Load . Below links will be helpful https://developer.teradata.com/connectivity/arti...
1226 Jun 2015 @ 06:22 PDTDatabaseReplyHow to get min and max value in a single olap query using ROW_NUMBER in teradata SELECT * FROM test_olap2 QUALIFY RANK () OVER (PARTITION BY customerID ORDER BY COALESCE (end_date,CURRENT_DATE +365) DESC ) =1 ORDER BY customerID ; Try using above query let me know if ...
1126 Jun 2015 @ 04:27 PDTDatabaseReplyPPI delete shows high estimatesHi , I forgot to ask you ,partition is on 1 month interval or 1 week inteval . if you have less partiton to delete then we can use partition no  for deleting all rows from that partition ...
1025 Jun 2015 @ 03:00 PDTDatabaseReplyPPI delete shows high estimatesHi,   I created similar scneario and loaded a table with 12 millions rows .   Explain before collecting stats on Partition and UPI 3) We do an all-AMPs DELETE from a single p...
924 Jun 2015 @ 02:59 PDTDatabaseReplyPPI delete shows high estimatescan you share some demographics of both tables and explain plan ?
824 Jun 2015 @ 02:56 PDTTeradata ApplicationsReplyExport multiple SQL's results into single excel sheet by sheetwhy do want to use Excel ? You can create comma separated file . keep the extension .txt Run all the queries one bye one , either export same data in one file or export dat of all queries in 5 fi...
717 Nov 2014 @ 12:36 PSTDatabaseReplyMLPPI Constraint ExplanationRun this Query if you want this thing --Will give All tables having more than one Partition defined on same Columns only -- SELECT DatabaseName ,TableName ,CASE WHEN SINGLE_CHAR = '@&...
615 Sep 2014 @ 04:12 PDTTeradata ApplicationsReplyQuestions on Inside AMPHi raja,   Same thing happens in spool space as well ? So my doubt is FSG Cache is unused Spool Space or Unused RAM memory ?
514 Sep 2014 @ 11:22 PDTTeradata ApplicationsReplyQuestions on Inside AMPHi Raja, Actually i have read this article .  I got confused when i was reading article on Joins Working. During Joins , the data is moved from vdisk to either in Spool Space or FSG cache ? ...
411 Sep 2014 @ 07:32 PDTTeradata ApplicationsTopicQuestions on Inside AMPHello Guys ,   I have some basic questions .  if you guys can help that will be really helpful.   Memory which used by AMP Vdisks Ram Sp...
318 Jun 2014 @ 09:47 PDTTeradata ApplicationsReplyHow to Pass mutliple values from text file to parametrized bteq Thanks alot Raja! Can we in a way so that i can pass all values to variable in one go and we can use IN operator in sql select * from tablename where Start_Date in ( {Start_Date1} ,{Start_Date2})...
218 Jun 2014 @ 07:47 PDTTeradata ApplicationsTopicHow to Pass mutliple values from text file to parametrized bteq Hi , i have extracted below two records in a file Start_Date     End_Date 2014-01-01    2014-06-30 2014-07-01    2014-12-31   i am pasing this a ...
106 Dec 2012 @ 05:05 PSTToolsReplyTD 13 Query Scheduler Startup Error on Windows 7 64-bitSQL Assistant does not contain the error message "Query scheduler start up error", or anything even remotely similar. It does check to see if TDQM/TQS is installed during startup... but ...