#DateForumTypeThreadPost
11530 May 2008 @ 02:33 PDTDatabaseReplyFew basic queriesThere is no DUAL table in Teradata.However you can achieve certain results in a different way.for example select 1 will give 1 as a result.
11428 May 2008 @ 01:12 PDTToolsReplySystem Emulation ToolPlease have a look at the paper "Teradata Analyst Pack - More Power to Analyze and Tune - Your Data Warehouse for Optimal Performance"authored By: Rod Vandervort, Jeff Shelton, and Louis Burgerpub...
11327 May 2008 @ 06:49 PDTJobsReplyNeed Teradata DBA for CTYou might get some interested 'genuine candidates' if you can share the profile of the DBA role in CT. BTW what is CT??
11227 May 2008 @ 06:45 PDTDatabaseReplyDATABASE ADMTeradata reduces DBA work by doing some activities by itself or never having to do certain activities at all.For example..1. Never need to reorganize data or index space which is required in some d...
11104 Apr 2008 @ 09:31 PDTToolsReplyLDM MappingWhat do you exactly mean by 'migration is done to Teradata'?From the operational system (business automated database) to a fresh warehouse?orFrom the datawarehouse of some xyz database product to a...
11004 Apr 2008 @ 09:19 PDTTrainingReplyPractice scripts/assignment for Teradata utilitiesI would suggest have a look at Teradata manuals of Application utilities. There are different manuals for Bteq, Fastload...etc and they have sample scripts.
10904 Apr 2008 @ 07:42 PDTTrainingReplyteradata DBA trainingJust start off with the introduction manual..."Introduction to Teradata". This might give an idea of whatis what in Teradata. Basic SQL is 'almost' the same in Oracle and Teradata. You might want t...
10804 Jan 2008 @ 09:24 PSTDatabaseReplySys_CALENDARCheck the following URL.http://www.teradataforum.com/teradata/20020612_213546.htm
10703 Jan 2008 @ 05:16 PSTTrainingReplyTeradata certified Master Jacket ?Once you pass all the 6 exams they will themselved send you a mail asking for your preferred size. You dont need to do anything. :-)
10631 Dec 2007 @ 07:49 PSTDatabaseReplyHow do we generate surrogate keys in teradata ?Why dont you try CSUM function? That might be simpler.
10531 Dec 2007 @ 12:59 PSTDatabaseReplyTeradata database version command.select * from dbc.dbcinfo
10424 Dec 2007 @ 02:51 PSTDatabaseReplyhi frnds, what r the olap functionsFor some unknown reason I am seeing only the below in the message sent by you. I am replying based on the statement in the subject. ;-)From the web:On-Line Analytical Processing (OLAP) functions pr...
10318 Dec 2007 @ 03:57 PSTDatabaseReplyMemory error--This is from the error messages manual.UTY3404 Internal memory allocation error.Explanation: Internal errorGenerated By: UMUCNTINRemedy: If this event recurs, contact the Global Support Center.
10218 Dec 2007 @ 03:51 PSTDatabaseReplyPlease help with Drop Database problemPermanent journals created and forgotten are potential source of frustration for the beginners. :-)
10118 Dec 2007 @ 03:45 PSTDatabaseReplyHow to create Table Scripts--Please direct the output of the below SQL to a bteq script and execute the same.select ' show table ' || trim(both from databasename) || '.' || trim(both from tablename) || ';' as tabledefn from...
10018 Dec 2007 @ 03:08 PSTDatabaseReplysumankonchada@rediffmail.comAn implicit join canbe distinguished from explicit joins where the keyword JOIN is part of the syntax.An implicit join like the following example uses just the simple FROM clauseselect ****FROM emp...
9918 Dec 2007 @ 02:59 PSTDatabaseReplyHow to get the last update date on a tableIt is pretty easier to find that out id query logging is activated.
9818 Dec 2007 @ 02:53 PSTToolsReplyTerdata sqlCheck this. It is interesting and helpful.Process for Analyzing Problem Queries Blood, Glen (The Coca-Cola Company) http://www.teradataforum.com/library.htm
9718 Dec 2007 @ 02:50 PSTToolsReplycan any body tell me data distribution on primary and secondary indexesJust go through the PI and SI chapters of Introduction to Teradata (Teradata manual).
9618 Dec 2007 @ 02:48 PSTToolsReplyNeoviewI dont know if there is any answer to your question. But there is something interesting which I found related to your topic.http://www.seriousaboutconsulting.com/2007/03/hp-neoview-head-to-head-wit...
9518 Dec 2007 @ 02:44 PSTTrainingReplyVersion 12 certificationAny URL for the beta tests which are active as of now?
9418 Dec 2007 @ 02:38 PSTTrainingReplyQuestion regarding marks weightage in certificationCongratulations. The fun of taking an exam lives when there is some uncertainity on the evaluation.
9318 Dec 2007 @ 02:35 PSTDatabaseReplyInterval of DAYs is only an estimate?Is that so? I ran the below SQL 2 times. select current_timestamp, current_timestamp + interval '1' DAY Current TimeStamp(6) (Current TimeStamp(6)+ 1) 2007-12-18 02:33:09.540000+00:00 2007-12-19 02...
9218 Dec 2007 @ 02:29 PSTDatabaseReplyloading from Unix or MainframeThe question is not very clear. Data is loaded from both mainframes and Unix clients. Do you mean to ask which one is faster and reliable? If yes..then both are reliable and both are fast and it al...
9118 Dec 2007 @ 02:24 PSTTrainingReplySQL examTwo pence advice:Don't depend on just question banks. Better try out all SQL's on Teradata box. Else you might have certification but might not be able to recall the required SQL constructs when re...

Pages