All forum activity

#DateUserForumTypeThreadPost
5901908 Aug 2016 @ 05:21 PDTJonathan.SDatabaseTopicLooking to count the first event in a colum Hi, I am trying to identify a repeat caller as deliniated by group code I have a data set as that has a colum of event id's (that can potentialy be duplicates) a colum of interaction id's ...
5901808 Aug 2016 @ 12:02 PDTdbrownDatabaseReplyNeed help with interdependent calculation using result from previous rowWould a loop or recursive query apply to this scenario? If so, can someone please help me understand how this can be accomplished? 
5901708 Aug 2016 @ 11:09 PDTJohannes VinkGeneralReplyImprove performance on an analytical query , mulitple columns using same set of partitionsAnd what would a simple sum/group by do? I sometimes think that an analytical fuction is executed seperately. It is cool stuff, sometimes performs like crazy. But in some case it doesn't.
5901608 Aug 2016 @ 10:59 PDTkenwill77ConnectivityReplyExcel 2016 VBA ConnectionHas there been an update to this yet? Is there truly a MSFT patch to resolve this? We are experiencing the same issue.
5901508 Aug 2016 @ 10:57 PDTTCPP_Cert_GuyTrainingReplyNeed help to find out Teradata certification materialInformation on authorized exam preparation materials for Teradata certification exams is located on the TCPP web site.   “Brain dumps” are not an authorized way to prepare for Te...
5901408 Aug 2016 @ 10:32 PDTToddAWalterGeneralReplyImprove performance on an analytical query , mulitple columns using same set of partitionsCan you provide explain please?
5901308 Aug 2016 @ 10:29 PDTjkurdsjukData ModelingReplyHow to transform an LDM to a PDM / Building block or Datamart?I should also mention that we have just added some instructor led courses to the Teradata Education Network that have several modules built around the transition from logical to physical model.&nbs...
5901208 Aug 2016 @ 10:11 PDTfgrimmerTeradata StudioReplyTeradata Studio does not show all of my authorized tables-@tdcvgrao, I ran a test but was not able to recreate your problem. My test set the preference to the custom option, closed Studio (red 'X') and brought it back up. Verified the Databases li...
5901108 Aug 2016 @ 10:02 PDTjkurdsjukData ModelingReplyHow to transform an LDM to a PDM / Building block or Datamart?Koentje, With all current Industry Data Models we provide what we refer to as the Physical Design Concepts Reference Manual.  While not exactly a "How To" manual, it does walk throu...
5901008 Aug 2016 @ 10:00 PDTfgrimmerTeradata StudioReplyTeradata Studio does not show all of my authorized tables-@tdcvgrao, The default is using the DatabasesV view and Studio should not be changing to custom automatically. How did you close Studio, File>Exit or red 'X' in upper right hand corner? ...
5900908 Aug 2016 @ 08:40 PDTtdcvgraoTeradata StudioReplyTeradata Studio does not show all of my authorized tables-Thanks for your reply and suggestion. Yes for some reason the default got changed to 'custom option' and I have changed it to DBC.DatabasesV and it worked.  But everytime when I login ...
5900808 Aug 2016 @ 08:35 PDTKoentjeData ModelingTopicHow to transform an LDM to a PDM / Building block or Datamart?We were starting the eDWH in the early 2000 by impleting the FS-LDM as a physical model (more or less, slightly adapted to our needs). This is working fine, but there are also, let's say from ...
5900708 Aug 2016 @ 08:27 PDTmpmchicToolsReplyFastload error: I/O Error on File Open 34  DEFINE    NPI001_NPI  (VARCHAR(128)),    NPI002_Entity_Type_Code  (VARCHAR(128)),    NPI003_Replacement_NPI  (VARCHAR(128)...
5900608 Aug 2016 @ 06:34 PDTfranceszhuDatabaseReplyA table with non-latin characters in table name and column names doesn't display properlyActually I don't know the character set. I can't get it from the command. Following is the result when I used the command to get the default character set type:    BTEQ -- En...
5900508 Aug 2016 @ 06:31 PDTdavidlarge22DatabaseTopicLooking for keywords in a string of text in a variable from another tablehi all,   i have ran out of ideas for this one    i have a table where there are 4 results that have keywords in them so    Word  a b c d and i have another...
5900408 Aug 2016 @ 06:16 PDTiozeeConnectivityTopicError while getting database functions via JDBCHi, when I call java.sql.DatabaseMetaData#getFunctions method, I get the following error: [Teradata JDBC Driver] [TeraJDBC 15.10.00.22] [Error 165] [SQLState HY000] getFunctions: function not sup...
5900308 Aug 2016 @ 05:11 PDTjester666Teradata Database on AWSReplyAWS instance unreachable for Teradata Database Developer (Single Node)Thank you for fixing this bug. The AMI of 08/05/2016 deploys fine now.
5900208 Aug 2016 @ 04:56 PDTTCPP-AdminUDATopicFirst Teradata Aster Certification Exam ReleasedThe Teradata Certified Professional Program is excited to announce the release of  the first Teradata Aster Certification Exam – Teradata Aster Basics 6.10.  Passing this exam will ...
5900108 Aug 2016 @ 04:55 PDTTCPP-AdminAsterTopicFirst Teradata Aster Certification Exam ReleasedThe Teradata Certified Professional Program is excited to announce the release of  the first Teradata Aster Certification Exam – Teradata Aster Basics 6.10.  Passing this exam will ...
5900008 Aug 2016 @ 04:54 PDTTCPP-AdminGeneralTopicFirst Teradata Aster Certification Exam ReleasedThe Teradata Certified Professional Program is excited to announce the release of  the first Teradata Aster Certification Exam – Teradata Aster Basics 6.10.  Passing this exam will ...
5899908 Aug 2016 @ 04:51 PDTPrivate Forum
5899808 Aug 2016 @ 04:49 PDTbkastermTeradata StudioReplyTeradata 15.1 Error when trying to execute queryTeradata studio express has worked fine for me; so that is my current solution, just use the express version.
5899708 Aug 2016 @ 03:08 PDTSoumyatgGeneralTopicImprove performance on an analytical query , mulitple columns using same set of partitions Hi, I have a large query where there are two window sets, one over year and another over quarter. I think that since teh parttion by and order by clause is same for 1 set of column and anoth...
5899608 Aug 2016 @ 01:05 PDTabhilash.dwbi@gmail.comToolsTopicReg: SQL Assistant download for Mac OSHi, I am looking for Teradata SQL Assistant for MAc Os, but am unable to find exact location/link to download  if any body provide me the download link and also installtion steps?  TIA
5899507 Aug 2016 @ 11:17 PDTSmacGeneralReplyMulti Column Primary Index and Secondary IndexThanks Fred. Now our requirement changes now. It seems acctid will also be used for joining and analysis purpose. Basically we need to use Accid alone for joining in some scenarios and Accid,bus ...

Pages