#DateForumTypeThreadPost
1931 Jul 2014 @ 02:59 PDTDatabaseReplyAvoid Product Join StepHi Dieter, The stats are up to date for these columns double checked what could be the issue. is there any way to find stale stats on table. Thank you.
1828 Jul 2014 @ 01:50 PDTDatabaseReplyAvoid Product Join StepHi Dieter, The actual rows are not in that range. And the stats on columns CLIENT_NBR and POP_ID are up to date. Here are the steps for spool 26 and 27. Spool 26:    2) We do a group-...
1725 Jul 2014 @ 02:18 PDTDatabaseTopicAvoid Product Join Step Hi, Could you please suggest how to avoid this product join step and explain about this step. Usually how should i understand this kind of steps all stats se...
1612 Apr 2012 @ 09:37 PDTJobsReplyLooking for Teradata DBA for Thailand Hey Gopi, You worked as a Mainframe developer on our client site last year How come you become a Teradata DBA in 1 year ...LOL whats the magic.......:) You give training from online ...
1506 Apr 2012 @ 12:41 PDTToolsReplySettting up Alerts policy first time on Teradata Manager 13.0 alert action sending email hi alvie, Now i set alert for number of sessions. If no.of sessions per user more than 2 it suppose to send a email. But the alert policy is not triggered even there are users more t...
1429 Mar 2012 @ 12:13 PDTTrainingReplyTeradata DBA Training Hi Gopi, Are you Mainframe or Teradata developer?   Looks like you'r mainframe developer i saw in other forums you posted as mainframe developer.   Just wonder&...
1326 Mar 2012 @ 07:48 PDTDatabaseReplyInformatica jobs failed with 'Teradata PT API Error' Hi goldminer, Appriciate your reply. We have eresloved this issue. This is due to there was chage is DNS(Domain Name Server) on network side this caused fails in teradata connection....
1221 Mar 2012 @ 06:45 PDTDatabaseReplyCalculate business days hours between two Timestamp(6) fields Hi ulrich, Yes, Im getting one row below. is there any other function do i add? Minimum(Policy_Enter_Time_Dt)    Maximum(Policy_Enter_Time_Dt)    Minimu...
1121 Mar 2012 @ 06:42 PDTToolsReplySettting up Alerts policy first time on Teradata Manager 13.0 alert action sending email I will try that and let you know.   Thank you alive.
1019 Mar 2012 @ 10:32 PDTDatabaseTopicInformatica jobs failed with 'Teradata PT API Error' Hi Professionals, We have some Informatica Mload jobs running daily and weekly since yesterday we are facing some job fails in production due to the below error we did not change any...
919 Mar 2012 @ 10:17 PDTDatabaseReplyCalculate business days hours between two Timestamp(6) fields Hi ulrich, Thank you for suggestion. After i remove the where condition and when i execute the query i got the below error after running 5 min SELECT Failed. 7453: Interval field overflo...
817 Mar 2012 @ 01:49 PDTToolsTopicSettting up Alerts policy first time on Teradata Manager 13.0 alert action sending email Our client is useing Teradata 13.0 and no ViewPoint. We are trying to set up some system alerts on Dev and Prod boxes for some critical events like CPU Skew, run out of space . I have co...
715 Mar 2012 @ 02:39 PDTDatabaseTopicAlert Policy created but not triggering any alerts on Teradata Manager 13.0 Hi, Our client is useing Teradata 13.0 and no ViewPoint. We are trying to set up some system alerts on Dev and Prod boxes for some critical events like CPU Skew, run out of space . I...
615 Mar 2012 @ 02:09 PDTDatabaseReplyCalculate business days hours between two Timestamp(6) fields Hi ulrich, Here is my coustom query i need time difference for each row not the entire rows i put group by in base table join and 'folder_id' is my base table key i just checked for ...
512 Mar 2012 @ 09:31 PDTDatabaseReplyCalculate business days hours between two Timestamp(6) fields Hi Sir, Never mind i'm under learning stage please do not wonder if i ask any simple things. Sure Sir, I Will love to donate some bugs to Unicef. Working on it will post my final...
409 Mar 2012 @ 07:57 PSTDatabaseReplyCalculate business days hours between two Timestamp(6) fields Hi Ulrich, In the bove query where to put my base table since both tables are sys_calendor and do i need to join this to my Client table to rid off the client holidays. Can you Please se...
307 Mar 2012 @ 03:01 PSTDatabaseReplyCalculate business days hours between two Timestamp(6) fields Hi ulrich, Working on it will reply if any issue. Appriciate your quick response.  
207 Mar 2012 @ 07:34 PSTDatabaseReplyCalculate business days hours between two Timestamp(6) fields Hi Ulrich, Thankyou for your reply.   We are using Teradata 13.0 version. Yes we have client specific calendor but it doesn't have Timestamp(6) field It has date and...
106 Mar 2012 @ 09:30 PSTDatabaseTopicCalculate business days hours between two Timestamp(6) fields Hi All, I have a business requirement for my client ono of the table have two Timestamp(6) fields 'Startdatets' and 'Enddatets' from this want to generate elapsed ti...