#DateForumTypeThreadPost
1320 Jan 2014 @ 10:44 PSTData ModelingReplyUsing a PPI column in PIHi Aarsh, any way 75% skew is not acceptable. So good you created PI with all three column and it is now only 5%. Now as per your usage of the SQL on this table there are possible scenarios - If...
1220 Jan 2014 @ 10:31 PSTDatabaseReplyCast-DATEThanks Dieter. It's good information. I'll try. However i see calendar_date columns is of Date datatype so extract function work fine. instead of calender_date if the column is of de...
1120 Jan 2014 @ 03:41 PSTDatabaseReplyCast-DATEHi Dieter, In our project,  date is stored in Decimal(16,0) and some dates are with 5 digits  91898  (mmddyy) , some dates are with 6 didgits 121898 (mmddyy) we need to c...
1019 Jan 2014 @ 10:23 PSTDatabaseReplyCase statement not pulling time between 18:31:01 and 19:00:00Is there any extra space or special characters while checking this condition.(which is not visible) Some times retyping the statment may solve these type of surprising issues. please try.
919 Jan 2014 @ 10:12 PSTGeneralReplydupliacate rowsHI Srivalli, I believe you are talking about the duplicate records based on your business columns leaving the audit date columns. if that is the case you might have unique primary index defi...
819 Jan 2014 @ 09:59 PSTTrainingReplyTeradata DBA Traninig in Hyderabad?Hi Prashant, I too attended Manohar's demo today and it was fantastic. I believe you might have completed your training by now. Can you let us know how is your overall experience an...
719 Jan 2014 @ 09:45 PSTTrainingReplyAny best Training Centres you guys know in Hyderabad??Hi all, I attended both the demos of Vinay and Manohar. Both are doing good job in training. Here is my opinion - Vinay is good at teradata development only class room training. If you are i...
617 Jan 2014 @ 07:56 PSTDatabaseReplyIndex QuestionCreate the Primary Index with a colum of more unique values. While creating Secondary index you need to see - 1) how frequently the combination of columns are being used in retrival. if usag...
516 Jan 2014 @ 11:12 PSTTrainingReplyTerdata Certification in IndiaHi Raja,  I'm not able to paste the links in my comments as you are pasting in forums. Am i missing any thing. Can you pls help.  
416 Jan 2014 @ 11:09 PSTTrainingReplyTerdata Certification in India http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/General_Reference/B035_1091_111A/title.01.2.html Hi Swathi, Above link may be useful to go through TD 14 document ...
315 Jan 2014 @ 10:10 PSTDatabaseReplyIssues with importing file with Date to Tableseems your default date format in target talble and the data formt in source file are different. while importing you may have to use below format converstion in insert statment - cast(:survey_dat...
215 Jan 2014 @ 10:03 PSTTeradata StudioReplyINMOD and OUTMODHi Raja, Inmod , outmode routines are object codes (executables ) of any third party language programs such as c, c++, cobal which would be used as pre or post processing correspondingly. For exa...
101 Mar 2013 @ 07:07 PSTTrainingReplyteradata DBA trainingAny good training institue to learn teradata

Pages