#DateForumTypeThreadPost
9018 Dec 2007 @ 02:06 PSTUDAReplyFAST PATH INSERT SELECTSorry for the typo...All Amps work parallelly because the source and target tables happen to be on the same Amp..
8918 Dec 2007 @ 02:04 PSTUDAReplyFAST PATH INSERT SELECTINSERT INTO PromotionSELECT Name, DeptNo, YrsExpFROM employee WHERE YrsExp > 10;When the primary indexes (or indices) of promotion and employee tables are the same column then FAST PATH INSERT S...
8818 Dec 2007 @ 01:59 PSTDatabaseReplyspool tables Primary Indexes and confidenceI dont think we can collect statistics on spool files directly.
8718 Dec 2007 @ 01:40 PSTUDAReplyTuning Teradata SQLJust a thought.Will creating an empty table first then fastloading the fastexported data (using a tuned select statement) make the execution duration less?Sometimes such workarounds make executions...
8621 Nov 2007 @ 02:05 PSTTrainingReplyTeradata Training - BangaloreThat was a prety good elaboration from Sanjay. If just learning Teradata is the goal then an alternative is self-learning. Get the demo CD and navigate the Teradata manuals. Long way but there is a...
8531 Oct 2007 @ 02:06 PDTThird Party SoftwareReplyTeradata NR0-013 v2R5 SQL CertifricationYou can never say anything about any exam. Better read all the advanced topics also. If NOT for the exam, we will never make a systematic learning during HOT phases of a project implementation. Fre...
8431 Oct 2007 @ 01:59 PDTDatabaseReplyNeed Study MaterialHello New member.Teradata training is available with Teradata-Mumbai.I dont think it is available with any institute in Karnataka.However there is a wealth of information to churn if you want to do...
8331 Oct 2007 @ 01:56 PDTDatabaseReplyAccessing Partition ID for a TableWhen I executed the below query "select partition, count(*) from tablenamegroup by 1"I got this error.5879: Invalid Partition field.
8230 Oct 2007 @ 08:48 PDTDatabaseReplyAccess Right AbbreviationsThank you. This is indeed useful.
8130 Oct 2007 @ 08:46 PDTDatabaseReplyVariables and BteqI dont think there is this ability.You might try a shell script or a piece of perl code. Like you can read a value file into a variable, generate your BTEQ script in a temp file, and execute it.
8030 Oct 2007 @ 08:39 PDTDatabaseReplyAre Teradata Demo CDs shipped to users across the globe?Yes. The demo CD- It is shipped across the globe.
7930 Oct 2007 @ 08:38 PDTDatabaseReplywhat are software components and hardware components in teradata system?Check out this site and see the below pdf files. You can understand Teradata components the way you asked.http://www.ncr.co.kr/media/media_center03.aspYesterday's Enterprise: Before Data Warehousin...
7830 Oct 2007 @ 08:31 PDTDatabaseReplyWhy data is stored in ROW ID is other databases and not in Teradata?May I request you to reframe your question? The question is not very clear.
7730 Oct 2007 @ 08:30 PDTDatabaseReplyWhat do you mean by Upgrading and Downgrading of a LOCK?There are primarily 4 types of lock severities ACCESS, READ, WRITE and EXCLUSIVE and u can apply these locks at different levels namely at Database level or Table or View or Row hash level. When yo...
7630 Oct 2007 @ 08:15 PDTDatabaseReplyIs Teradata a RDBMS?Check these for a brief over view.http://en.wikipedia.org/wiki/Teradatahttp://www.answers.com/Teradata?cat=technology
7530 Oct 2007 @ 08:12 PDTDatabaseReplyimportant improvements in V2R6.1 over V2R5Check this for brief information.http://www.teradata.com/t/page/130595/index.html
7430 Oct 2007 @ 08:09 PDTDatabaseReplyNeed Study MaterialCheck the technical documentation area of Teradata.com site.All Teradata manuals are there.
7330 Oct 2007 @ 08:03 PDTDatabaseReplyHow to find when the statistics was updated for an Teradata Table.Where was the right click done and on which object was the show statement used?
7230 Oct 2007 @ 07:59 PDTDatabaseReplyPartition Primary Index(PPI) and PIAn example from the Teradata SQL DDL manual.Example 15: Partitioned NUPI Specification With a USI On the Same ColumnSet and Partitioned By a RANGE_N ExpressionThe following example creates a NUPPI ...
7130 Oct 2007 @ 02:00 PDTDatabaseReplyPPIThis is an excellent explanation.So in short even if Teradata has allowed a Uniquness on the PI via UPI it will not serve any purpose because it anyway will search all the partitions. Atleast enfor...
7029 Oct 2007 @ 09:38 PDTDatabaseReplyEnterprise Reference ArchitectureThis is a pretty open ended discussion. I have come across one pdf file on the internet which explains what is that enterprise reference architecture. May be we will have better participation from ...
6929 Oct 2007 @ 09:23 PDTAnalyticsReplyRenaming , hiding or Deleting the existing legendsIs Legend a Teradata object? I have not heard about it. Can you elaborate other than the example you have used in the post?
6829 Oct 2007 @ 09:21 PDTAnalyticsReplyDeadlocks during ETL using InformaticaWhy dont you create corresponding views for the tables to be loaded with access locks defined in the view and then use these views for the load purposes rather than directly loading the tables. Thi...
6729 Oct 2007 @ 09:19 PDTAnalyticsReplyCOLLECT STATISTICSCheckout for a wonderful article by Carrie ballinger on Collect statistics. It might be available on Teradata.com site or Teradata Magazine site. Wealth of information is presented in that.
6629 Oct 2007 @ 09:14 PDTTrainingReplyTeradata Training - BangaloreI dont think so. AFAIK only Teradata Mumbai offers training officially.

Pages