#DateForumTypeThreadPost
1409 Feb 2013 @ 06:29 PSTTrainingReplyTERADATA CERTIFICATIONHi, I had a plan to preapre for TD 12 exms for a long time. But kept delaying it and now I am in a dilemma whether to go for it or wait for the TD14 exams to come in. i had 2 levels of V2R5 certi...
1305 Mar 2012 @ 06:26 PSTTrainingTopicTeradata Architect - role & responsibilities Hi, Can anyone please let me know what are the responsibilties of a teradata architect?  Should a teradata architect have data modelling experience? Is it helpful to have certificat...
1206 Feb 2012 @ 04:52 PSTDatabaseTopic3NF and Dimensional data model in Teradata Hi, What is the best method of modelling in Terdata? A 3NF or a dimensional database? When do we use a 2 layer model i.e a 3NF tables and dimensional tables together? What would be the busin...
1127 Jan 2012 @ 09:24 PSTUDATopicCollect stats in ETL Hi, I've been workinng on Teradata with the mainframes all through my experience. As per my current project, I had to use Datastage as ETL and I have a question here.  How do we...
1005 Sep 2011 @ 10:06 PDTTrainingReplyNeed help to find out Teradata certification material Hi all, I am planning to give Teradata 12 Basics TE0-121 exam.  As per the previous posts, i downloded the pdfs 1091.pdf, 1093.pdf  etc from Teradata website. Please let me...
924 Nov 2009 @ 02:00 PSTDatabaseTopicBYNET - Is it a h/w or s/wHi,I read in one of the teradata books that BYNET can be a software or a hardware component.Can anyone please explain this. Thank You
808 Nov 2009 @ 12:13 PSTDatabaseTopicBLOB and CLOBHi,What are large objects? Can you please lemme know the prominence of an BLOB an CLOB(Binary and Char Large objects)?Thank You
708 Nov 2009 @ 12:10 PSTDatabaseTopicDifferent Clients accessing a DatabaseHi,If Teradata has a feature of Single version of business i.e different clients accessing the same database server, how does this happen in other databases? Will the data be repplicated for differ...
608 Nov 2009 @ 12:05 PSTDatabaseTopicParallelism in other databasesHi,I would like to know 1) if there are any other databases with the concept of parallelism. What are the competitors for teradata in Market.2) What are the major differences between teradata and o...
502 Apr 2009 @ 04:08 PDTToolsReplyskip the header row in the flat file, when importing using FastLoad scriptHi,We can eliminate the first record of the flatfile by using a RECORD statement in the fastload script.RECORD 2;The above statement skips the first record in the flat file.Thank You
402 Apr 2009 @ 03:51 PDTToolsTopicUNIX vs MainframesHi,we run Teradata utilities both through UNIX and Mainframes.Can anybody please tell me in which scenario UNIX is preferable and when can we use mainframes to increase performanceThank You
317 Mar 2009 @ 03:04 PDTToolsTopicMload Vs FastloadHi,Which utility is faster Mload or Fastload if we are loading data into an empty table and why?Can we load duplicates into a multiset table with a NUPI using Mload?Thank You
217 Mar 2009 @ 02:55 PDTToolsTopicCollect Statistics on Empty tableWhat will happen if we collect statistics on an empty table?Do we face any complexities because of this?
117 Mar 2009 @ 02:54 PDTToolsTopicInformatica Vs TeradataHi,In our current project we are using Informatica and Teradata.All the operations done in Informatica can be done by Teradata SQL also.So can anybody tell me in which scenarios Informatica is bett...