#DateForumTypeThreadPost
1114 Sep 2009 @ 01:48 PDTDatabaseReplyOLAP function for rolling twelve month revenueIf I did understand correctly what's your need, I think that its possible to have it by this query :SELECT STORE_ID, CUSTOMER_ACCT_ID, (((CUSTOMER_ACCT_OPEN_DT ( DATE , FORMAT 'YYYY-MM'))(CHAR(7)...
1009 Sep 2009 @ 03:39 PDTToolsReplyVerify Version loadedfor BTEQ and F2ASTLOAD , invoke it and then enter the command :show versions;it gives you the information needed.other utilities might follow the same version
905 Sep 2009 @ 12:17 PDTDatabaseReply"2642: Amp Down. The Request against nonfallback CONTRACT cannot be done"This meens that your TD12 express edition installation failed somewhere. the TD express has configurted with 2 AMP's, and apparently at least one of them is on FATAL/DOWN state. check the am...
804 Sep 2009 @ 02:11 PDTDatabaseReplySubquery Issuewindowed analytical funstions are great, but they put troubles during optimization phase, because they introduce a disruption on relational theory and then its more dificult to optimize the overall...
704 Sep 2009 @ 01:48 PDTDatabaseReplySql to delete duplicates in TeradataThe question look simple but the response is not always easy!! If there is dups, it indicates that we don't have UPI's or USI's and/or the table is MULTISET. Let say that the simplest way is to u...
604 Sep 2009 @ 03:16 PDTDatabaseReplyQuestion about Dynamic Partition eliminationWhen you are using a little driver.lookup table which contains the values of the partitionning column, and if there is a small number of distinct values (in my clients experiences less than 100, bu...
503 Sep 2009 @ 02:57 PDTUDAReplyOracle Reports connectiing to TERADATADid you tried to make a link between Oracle and Teradata by using Oracle Transparant gatway thru ODBC ?Then you are enable to map Teradata table in an Oracle instance and then, map the oracle repo...
403 Sep 2009 @ 12:14 PDTDatabaseReplySubqueries WorkaroundThis as "scalar subquery", unless you are using TD13, it won't work on previous releases. btw you can use product join to do it : Select P.patient_name, P.Patient_age, P.Patient_weight, A...
303 Sep 2009 @ 07:49 PDTGeneralReplyWelcome to the Teradata Developer Exchange discussion forums!What about the old ATR does it move to this new forum ?
203 Sep 2009 @ 01:36 PDTGeneralReplyTeradata Database Installation Problem - Unable to Open File "Services"do you have administrative writes on your XP box ?
103 Sep 2009 @ 01:35 PDTDatabaseReplyQuestion about Dynamic Partition eliminationwhen you are using a driver table for peeking dates, the DPE will generate a "product join enhanced by dynamic partition elimination.....". Regardless on how mush data you have in the table, this c...

Pages