#DateForumTypeThreadPost
1013 Jul 2016 @ 12:02 PDTDatabaseTopicRegarding Teradata MigrationWe are planning to do a Teradata migration, the versions for source and target Tearadata is close (source Teradata version 15.00.02.02, though not sure about Target version yet). The migration is h...
915 Jan 2014 @ 02:59 PSTDatabaseReplyAccount balance SQLHi Saeed, Your query will give below output : A_date A_bal 1/1/2014 10,000 1/15/2014 15,000 1/25/2014 13,000 But I want the output in the below way where all the 31 days of Januar...
814 Jan 2014 @ 11:58 PSTDatabaseTopicAccount balance SQL A_date A_bal 1/1/2014 10,000 1/15/2014 15,000 1/25/2014 13,000   I have sample account balance information as shown above. i.e. 01-Jan 10K, 15th J...
711 Dec 2013 @ 11:22 PSTDatabaseReplySQL to transpose (row to column) any level (nth level) of dataThanks for your reply, but when I will have a dataset like below : Tgt Src lvl ============ ============ ==== L4_Tab1.Col1 L3_Tab2.Col3 0 L4_Tab1.Col4 L3_Tab2.Col1 0 L4_Tab1....
611 Dec 2013 @ 12:18 PSTDatabaseReplySQL to transpose (row to column) any level (nth level) of dataHi Khurram, My question is little different. In my example there is a linkage between Src column value of lvl=0 with Tgt column value of lvl=1 Source Data Tgt Src lvl L3_Tab1.C...
510 Dec 2013 @ 11:53 PSTDatabaseReplySQL to transpose (row to column) any level (nth level) of dataSource Data Tgt Src lvl L3_Tab1.Col1 L2_Tab1.Col3 0 L3_Tab1.Col2 L2_Tab2.Col2 ...
410 Dec 2013 @ 11:50 PSTDatabaseTopicSQL to transpose (row to column) any level (nth level) of dataHi, I have a data like below: Tgt Src lvl L3_Tab1.Col1 L2_Tab1.Col3 0 L...
304 Oct 2012 @ 07:51 PDTGeneralTopicServer configuration for TDE 13.10.00.10 for VM Ware (1 TB) installationHi, Can any one please let me know the configuration required for a Linux VM Ware server for "TDE 13.10.00.10 for VM Ware (1 TB)" installation, considering approximately 100 concurrent u...
230 Sep 2012 @ 11:47 PDTGeneralTopicGeneral Information on Teradata SoftwareHi, We are actually at the start of a project on Teradata and for that we want build and/or enhance skill on Teradata of the resources who will be working on it. Could you please let me know that ...
124 Sep 2012 @ 01:53 PDTToolsTopicDate (Y2K) IssueHi, I have installed "Teradata Express 13 - Windows" for learning purpose. Now when I am executing the query below in "Teradata SQL Assistant" I am getting output as "12/2...