#DateForumTypeThreadPost
406 Sep 2012 @ 11:43 PDTDatabaseReplyPartition Elimination not happening in Fact through Time Dimension filter. Hi Manik I faced similar issue in ETL, but solved using stored procedures. In my case Partition elimination->join and full table scan>join had time difference of huge 30 Min. ...
304 Sep 2012 @ 09:04 PDTDatabaseReplyProbable bug in Teradata v13 SELECT '2012-02-10' - EXTRACT(DAY FROM '2012-02-10') Answer set is 20120200.00  I've mentioned it in single quotes to identify it as char. But database process th...
204 Sep 2012 @ 08:22 PDTDatabaseReplyCurrent Month End Date SEL ADD_MONTHS(CURRENT_DATE-EXTRACT(DAY FROMCURRENT_DATE),1); will have problem for date '2012-03-01'(March). Solution is  Vikas's query.
104 Sep 2012 @ 07:29 PDTDatabaseReplyTeradata Update Syntax  [3993 - illegal usage of alias name] occured due to alias name for target table in SET. Rewrite below part, set k.sales_count = m.sales_count ,k.sales_sum = m.sales_sum to set s...