#DateForumTypeThreadPost
4229 Dec 2006 @ 01:43 PSTTrainingReplyPlease replyHi I suggest you order this FREE CD from NCR TeraData site. http://www.teradata.com/t/page/156360/index.html
4129 Dec 2006 @ 01:41 PSTTrainingReplyCost of Basic certificationHi I suggest you goto http://www.prometric.com/Default.htm and check the current Prometric rates for you country. In South Africa they vary around $170 to $210.
4029 Dec 2006 @ 01:31 PSTTrainingReplyIs it okay to post questions and their answers from a recent exam on this forumHiNO it is not ethical or allowed. Should NCR find out you WILL lose any Certification you would have, this is because you sign an agreement when you write the exam that you will not reveal the exa...
3929 Dec 2006 @ 01:23 PSTTrainingReplyApplication developer and Designer examsHiThe Coffing bvooks are expensive but well worth every cent spent. I personally will never part with miy copies.Maybe look at attending one of Tom Coffings courses if he is in you area and then yo...
3829 Dec 2006 @ 01:20 PSTTrainingReplyImplementation & SQL examsHiTom Coffings book as really good but I suggest you get some training and experience behind you as well as some questions will might need rely on your experience and past exam knowledge.I personal...
3729 Dec 2006 @ 01:13 PSTTrainingReplyPhy Imp clearedHi VanrunCongratulations!!! Just remember the SQL is really tough and tricky so take you time, study, practice and study some more and you should past.I presonally found SQL the most difficult (and...
3602 Nov 2006 @ 02:13 PSTAnalyticsReplyconversion of datatypeHiYou can only cast to Decimal(18,?) so if your numbers are expected to be up to 18 then is fine. Otherwise you can try casting to a character or some other numeric type.
3502 Nov 2006 @ 01:52 PSTTrainingReplywhat is wrong with prometric?HiFrom the day I started my TDM till I finished it I never had one problem with PROMETRIC.Might be a problem in the USA, call them or e-mail them to fix.
3402 Nov 2006 @ 01:39 PSTTrainingReplyTeradata BASICS examination..!!HiAs far as I know only the V2R5 exams are available and that the new examinations will be for V2R7.I wrote a similar letter to someone about this and I think it is relevant to your senarion:...The...
3326 Oct 2006 @ 07:07 PDTDatabaseReplyBteq Export LImitation???HiWell divide the file into two parts by using a where clause in the EXPORT SQL and create two individually files.
3226 Oct 2006 @ 07:04 PDTDatabaseReplyNetbackup 5.1Hi RickWe used NetBackup and it worked very well, we have changed to NetVault 7.2 because there were issues with our UNIX system backup on the other UNIX servers.The Windows interface is very eary ...
3126 Oct 2006 @ 07:00 PDTDatabaseReplyWhy No confidenceHiTry the NCR site at http://www.info.ncr.com/
3026 Oct 2006 @ 06:54 PDTDatabaseReplyCollect statistics questionHi You're correct. Try collecting stats only on the columns that are referenced in WHERE clauses or on your indexes.
2926 Oct 2006 @ 06:52 PDTDatabaseReplywhat is diff stats on coln and Index.HiThe question you need to ask is whcih column will I be accessing the most and Collect Stats on them. It is alos a very good idea to collect stats on ALL index columns, especially on the UPI NUPI.
2826 Oct 2006 @ 06:49 PDTDatabaseReplywhether row hash changes when new nodes or Amp added?HiYes it will, providing you have more AMP's. The Row hash is always the same and a record will always be put on the same AMP but if you upgrade you system and add more AMP's this will change and n...
2726 Oct 2006 @ 06:46 PDTDatabaseReplyHelp on SET/MULTISET.. plzzHiAny answers yet?
2626 Oct 2006 @ 06:44 PDTDatabaseReplyIdentity Column as Composite UPIHiIs it the first column of UPI?
2526 Oct 2006 @ 06:41 PDTUDAReplyGetting bteq to just return the resultHiTD no can do, unless you write a program ...
2426 Oct 2006 @ 06:01 PDTAnalyticsReplysimple formatting questionHiThe CAST works best but you can also use the FORMAT option as follows:Select emp_id, NumAccts, 123.45/NumAccts (decimal(6,4))as NewNum,15/NumAccts (decimal(6,4))as NewNum2,15/NumAccts (decimal(6,...
2326 Oct 2006 @ 05:36 PDTTrainingReplyPublicly available Teradata Material (Other than Coffingdw n Teradata SiteHiLook okay but only browsed, the Tom Coffing Books are the BEST. I used them in my preperation and they helped a lot. You can also practice exams at his web site, which is http://www.coffingdw.com...
2226 Oct 2006 @ 05:33 PDTTrainingReplyWhere to download the Teradata database server and Utility packsHiYou can get/order a copy of TeraData Demo at http://www.teradata.com/t/page/156360/index.html
2126 Oct 2006 @ 05:09 PDTDatabaseReplySoft RIHiJust how soft? Remeber your data should already be in the 2nd Normal form.There are no draw back to going higher and higher accept:-- That you might cause redundancy-- Multiple table joins to ret...
2026 Oct 2006 @ 04:39 PDTDatabaseReplyblocking informatuin in dbc viewsHiI am not sure what blocking information you are looking for. Normally a view is a subset of a table contain the fields you want everyone to view. ie. you may want to allow people to view employee...
1926 Oct 2006 @ 04:30 PDTDatabaseReplyFunctionalities of AMPsHi NO as user does not configure the AMPs, this is done by NCR at installation and setup of the TeraData box.An AMP is physical space, memory and CPU, whcih are the "worker bees" (Thanks Tom Coffin...
1826 Oct 2006 @ 04:27 PDTDatabaseReplyTDP-IDHiInorder to access BTEQ you must ensure that you have your TeraData system defined in your ETC\host file (c:\windows\system32\drivers\etc). You must open this file, you can use NOTEPAD for this.Th...

Pages