#DateForumTypeThreadPost
4023 Oct 2007 @ 04:36 PDTTrainingReplyTeradara Certification - Application Developer and Physical implementationDatabase Design PDF (1094) would be your starting point for both Physical Implementation and Design Architecture
3918 Oct 2007 @ 01:09 PDTTrainingReplyHow many Certified Teradata MastersOlivia Baronner, The ex-TCPP Program Manager has quoted in her last email that the number has reached 1300
3818 Oct 2007 @ 12:46 PDTDatabaseReplyHow to find when the statistics was updated for an Teradata Table.You may also look at Dieter's Query for more efficient information on Statistics. You can find that in the archives.
3720 Aug 2007 @ 02:38 PDTUDAReplytrying generate a unique idIf your table definition for that column is GENERATED ALWAYS, then, an unique number is generated always.
3618 Jun 2007 @ 03:06 PDTDatabaseReplyMistake in statement's syntaxYou could try something like below:SELECT CASE WHEN 1070618 > 0 THEN cast(1070618 as DATE format 'dd-mm-yy') ELSE null endThe above statement would return:*** Query completed. One row found. One c...
3506 Jun 2007 @ 11:48 PDTDatabaseReplyDifference between Database and userBoth may own objects such as tables, views, macros, procedures, and functions. Both users and databases may hold privileges. However, only users may log on, establish a session with the Teradata Da...
3417 May 2007 @ 04:59 PDTDatabaseReplyDates In Decimal FormatOk. I get 11/22/2007 for the same query in my SQL Assistant.
3317 May 2007 @ 04:46 PDTDatabaseReplyDates In Decimal FormatThis is what I got in bteq:BTEQ -- Enter your DBC/SQL request or BTEQ command: select cast(cast(112207 as char(6)) as date format 'mmddyy');select cast(cast(112207 as char(6)) as date format 'mmddy...
3217 May 2007 @ 04:15 PDTDatabaseReplyDates In Decimal FormatOne way is to convert them to char and then to date....select cast(cast(112207 as char(6)) as date format 'mmddyy')
3110 May 2007 @ 04:21 PDTUDAReplyCount(*)In other words, count(a.colname) excludes all the null value and returns the count, on a column which can hold null value.
3003 May 2007 @ 11:06 PDTAnalyticsReplyRounding up to whole numberI guess, by default date - date would return integer... So, another casting to interger may not be required
2903 May 2007 @ 10:26 PDTConnectivityReplyUDF in place of a MacroYes. That's exactly I did, if you take a look at my macro. But, I was trying to ask if the same logic can be replicated as an UDF so that, Business Objects can use this at the row level.
2802 May 2007 @ 12:41 PDTConnectivityReplyUDF in place of a MacroNot really. I was looking for some inputs on using an equivalent for sys_calendar.calendar table.
2730 Apr 2007 @ 11:06 PDTTrainingReplyExam PricesYou should be able to get that information from the prometric's website. Prices starts from 124 GBP to 132 GBP.Click on the below URL:http://www.register.prometric.com/Exam.asp
2626 Apr 2007 @ 12:47 PDTToolsReplyDate Diff in Teradataselect (current_date - date '2007-04-01') - count(calendar_date) from sys_calendar.calendar where day_of_week in (1,7) and calendar_date between date '2007-04-01' and current_date;The above query ...
2525 Apr 2007 @ 03:08 PDTToolsReplyColumn gets truncated and gets insertedI don't think, character columns return an error, if there is an overflow...
2417 Apr 2007 @ 02:28 PDTDatabaseTopicUDF in place of a MacroHiI've the following macro, which calculates the business hours for a time period leaving out the weekends:CREATE MACRO BHRS (CLOSEDTM TIMESTAMP, STRTDTM TIMESTAMP, BUSHRSPERDAY INTEGER, WKNDHRS IN...
2317 Apr 2007 @ 02:27 PDTConnectivityTopicUDF in place of a MacroHiI've the following macro, which calculates the business hours for a time period leaving out the weekends:CREATE MACRO BHRS (CLOSEDTM TIMESTAMP, STRTDTM TIMESTAMP, BUSHRSPERDAY INTEGER, WKNDHRS IN...
2225 Oct 2006 @ 11:35 PDTTrainingReplyWhere to download the Teradata database server and Utility packsWhat kind of software download, you are looking for? If you are looking for a demo software, don't think, you can download from the web. You need to request for your personal copy.
2116 Sep 2006 @ 12:34 PDTDatabaseTopicER or Dimensional model?Hey FolksJust wanted to know, what type of model would you design, if you are implementing data marts in Teradata? NCR Teradata recommends ER model, normalized upto 3rd normal form.. Is this the go...
2016 Sep 2006 @ 12:31 PDTUDATopicER or Dimensional Model?Hey FolksJust wanted to know, what type of model would you design, if you are implementing data mart in Teradata? NCR Teradata recommends ER model, normalized upto 3rd normal form..Is there any doc...
1907 Sep 2006 @ 01:35 PDTDatabaseReply10065 WSA E HostUnreachThere you go...So, the problem is with the IP address. You need to find out where this is getting resolved.
1807 Sep 2006 @ 12:27 PDTDatabaseReply10065 WSA E HostUnreachWas the firewall completely shut off? Did you go to control Panel and shut down your firewall?When I shut down my firewall and tried connecting, I was able to do that.There are few tests, which you...
1706 Sep 2006 @ 01:00 PDTDatabaseReply10065 WSA E HostUnreachWas your teradata service started at that time?Did you turn off the firewall and then started the teradata service?If not, start the teradata service and then try the above commands.Let me know, if...
1605 Sep 2006 @ 10:54 PDTDatabaseReply10065 WSA E HostUnreachWell, Welcome to this club. :-)I recently got my Teradata working after having the same issue.Do you have your firewall on?If yes, shut down all the firewall and then try connecting to Teradata aga...

Pages