#DateForumTypeThreadPost
18413 Oct 2009 @ 04:57 PDTDatabaseReplyThoughts on CPUBusy caclulations.Random_thoughts, you rock! Great information!
18310 Oct 2009 @ 08:18 PDTDatabaseReplyThoughts on CPUBusy caclulations.Thanks for the information Random_thoughts! This is very useful. I would like to ask few more questions regarding the CPU Usage by a Query per user.Hope you will help me understand. (1)Will t...
18208 Oct 2009 @ 01:15 PDTDatabaseReplyThoughts on CPUBusy caclulations.Can we compare the CPU calculated from Resusage table with one shown in DBQLogtbl? The above discussion, talks about systemwide CPU utilization on a day and Hour basis. DBQLogtbl also shows us T...
18103 Sep 2009 @ 02:44 PDTDatabaseReplyQuestion about Dynamic Partition eliminationAgreed that it is advantageous to Hardcode the dates so that parser knows what partitions it is going to access.But, When we have dates driven by a reference table, How bad (or Good) is Dynamic Par...
18002 Sep 2009 @ 10:29 PDTToolsTopicTeradata Geospatial application setup -help needed?Can someone guide me in installing teradata Geospatial software? I have the following setup 1.Teradata database version 12.0 running on Linux server 2.Teradata Tools and utilities Version T...
17902 Sep 2009 @ 09:53 PDTDatabaseTopicQuestion about Dynamic Partition eliminationI have a scenario where I will have to design a SQL in my ETL job to retreive rows from a PPI table.The PPI is defined on a date column. As per the schedule my ETL Job runs every 15 days and I will...
17812 Aug 2009 @ 03:22 PDTToolsTopicMultiple Sessions Setting in Teradata Tools and utilitiesI see that we can set the number of sessions in BTEQ. How does this multiple session setting work in BTEQ? If I run a Batch script in BTEQ with number of sessions set to more than 1, Will I see ...
17712 Aug 2009 @ 11:38 PDTToolsTopicNumber of SessionsWe have a facility to teach Multiload,Fastload and BTEQ to use multiple sessions. I wouldlike to understand how this setting works. I.e., If I specify, Set Sessions 5 in BTEQ script how does it wor...
17623 Feb 2009 @ 02:05 PSTToolsReplyTPT Vs other ETL UtilitiesThank you, Your posting was quite informative.Here is another question for you. Talking about Data streams, what exactly are they? Is it the system Memory or the portion of Disk drive? How effectiv...
17516 Feb 2009 @ 04:54 PSTToolsTopicTPT Vs other ETL UtilitiesWhat is the key factor that makes TPT better than other Load utilities.Given that it uses SQL like language syntax but invokes various Load utility protocols.How is it different and similar from ot...
17407 Jan 2009 @ 05:50 PSTViewpointReplyCould not run startup.bathmmmm! another glitch in the adventure neil. I tried to create a sample portlet as discussed in the manual..however, the portel shows me a page which says the application server is running but does...
17306 Jan 2009 @ 07:23 PSTViewpointReplyCould not run startup.batNeil,Finally, I have got this one to work.I cleaned up all the redundant Java releases on my system.Edited the xml files as described in the Installation guide and ran the batch files. The Applicat...
17202 Dec 2008 @ 06:07 PSTViewpointReplyCould not run startup.batWell, Im running JDK 1.5.x (see the path C:\Program Files\Java\jdk1.5.0_02).How are there are more than one versions of java run-time environment installed, starting jre 1.5.x,1.6.x.Do you have rec...
17102 Dec 2008 @ 05:57 PSTViewpointReplyCould not run startup.batI suspect the problem is due to classpath only.I have taken care to install the TDK pack.The following is my system class path.;C:\Program Files\Java\jre1.6.0_07\lib\ext\QTJava.zipdo you have any r...
17002 Dec 2008 @ 04:29 PSTViewpointReplyCould not run startup.batBut when I try to access the page http://localhost:8080/, it shows me the following HTTP Status 404 - /--------------------------------------------------------------------------------type Status re...
16902 Dec 2008 @ 03:43 PSTViewpointTopicCould not run startup.batI am freshly installing teradata View point on my system. I have followed the instructions in the instruction manual. Once I ran the setup.bat successfully, I am not able to startup the Teradata Vi...
16802 Dec 2008 @ 03:18 PSTAnalyticsReplyCastselect date (format 'mm/yyyy');select date (format 'mm/yyyy'); *** Query completed. One row found. One column returned. *** Total elapsed time was 1 second. Date-------12/2008
16724 Sep 2008 @ 12:08 PDTDatabaseTopicV12 and StatisticsHow confident is teradata V12 regarding the statistics? Till how many sub-query levels does V12 carry the statistics information? Had anybody found any difference in the way confidence levels chang...
16624 Sep 2008 @ 11:58 PDTDatabaseTopicMERGE Vs INSERT Vs UPDATEWhat is the difference between MERGE,UPDATE and INSERT. How does teradata internally process each of these request? I know the basic difference between what INSERT or UPDATE does, but, I wanted to ...
16516 May 2008 @ 04:56 PDTDatabaseReplyNew line character in Dynamic SQL.I have a similar kind of situation here, I want to use equivalent of newline ("/n") in my query. Iam trying to generate a query using another query.The new query might be long enough. So I want to ...
16404 Mar 2008 @ 12:58 PSTDatabaseTopicHash JoinsAre there any downsides of using Hash Joins. Apart from disabling the Hashjoins thru dbscontrol, is there any other way that a user can dictate teradata to not to choose Hash joins for their querie...
16318 Feb 2008 @ 10:25 PSTDatabaseReplyLT,WT,ET,UV tablesNot very sure on this...but,let me give it a shot!When u get a error ,the information is stored in the error table. I beleive mload job will be paused/aborted when there is a run time error/data er...
16214 Feb 2008 @ 03:05 PSTToolsReplyteradata profilerThanks for the info Annal
16114 Feb 2008 @ 03:01 PSTUDAReplyCorelated Sub QueriesWhen an instance of outer relation(table) is also refered in the inner sub-query, the query is said to be co-related. exampleselect....fromtableA A where fld1=(select fld2 from tableB B where B.fld...
16014 Feb 2008 @ 02:48 PSTToolsReplyMload: Update duplicate rowsI beleive Multiload supports Upsert operations.Upsert essentially updates a row id it already exists otherwise inserts it into the table.refer manuals to know how upsert works.

Pages