184 | 13 Oct 2009 @ 04:57 PDT | Database | Reply | Thoughts on CPUBusy caclulations. | Random_thoughts, you rock! Great information!
|
183 | 10 Oct 2009 @ 08:18 PDT | Database | Reply | Thoughts 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... |
182 | 08 Oct 2009 @ 01:15 PDT | Database | Reply | Thoughts 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... |
181 | 03 Sep 2009 @ 02:44 PDT | Database | Reply | Question about Dynamic Partition elimination | Agreed 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... |
180 | 02 Sep 2009 @ 10:29 PDT | Tools | Topic | Teradata 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... |
179 | 02 Sep 2009 @ 09:53 PDT | Database | Topic | Question about Dynamic Partition elimination | I 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... |
178 | 12 Aug 2009 @ 03:22 PDT | Tools | Topic | Multiple Sessions Setting in Teradata Tools and utilities | I 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 ... |
177 | 12 Aug 2009 @ 11:38 PDT | Tools | Topic | Number of Sessions | We 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... |
176 | 23 Feb 2009 @ 02:05 PST | Tools | Reply | TPT Vs other ETL Utilities | Thank 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... |
175 | 16 Feb 2009 @ 04:54 PST | Tools | Topic | TPT Vs other ETL Utilities | What 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... |
174 | 07 Jan 2009 @ 05:50 PST | Viewpoint | Reply | Could not run startup.bat | hmmmm! 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... |
173 | 06 Jan 2009 @ 07:23 PST | Viewpoint | Reply | Could not run startup.bat | Neil,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... |
172 | 02 Dec 2008 @ 06:07 PST | Viewpoint | Reply | Could not run startup.bat | Well, 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... |
171 | 02 Dec 2008 @ 05:57 PST | Viewpoint | Reply | Could not run startup.bat | I 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... |
170 | 02 Dec 2008 @ 04:29 PST | Viewpoint | Reply | Could not run startup.bat | But when I try to access the page http://localhost:8080/, it shows me the following HTTP Status 404 - /--------------------------------------------------------------------------------type Status re... |
169 | 02 Dec 2008 @ 03:43 PST | Viewpoint | Topic | Could not run startup.bat | I 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... |
168 | 02 Dec 2008 @ 03:18 PST | Analytics | Reply | Cast | select 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 |
167 | 24 Sep 2008 @ 12:08 PDT | Database | Topic | V12 and Statistics | How 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... |
166 | 24 Sep 2008 @ 11:58 PDT | Database | Topic | MERGE Vs INSERT Vs UPDATE | What 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 ... |
165 | 16 May 2008 @ 04:56 PDT | Database | Reply | New 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 ... |
164 | 04 Mar 2008 @ 12:58 PST | Database | Topic | Hash Joins | Are 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... |
163 | 18 Feb 2008 @ 10:25 PST | Database | Reply | LT,WT,ET,UV tables | Not 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... |
162 | 14 Feb 2008 @ 03:05 PST | Tools | Reply | teradata profiler | Thanks for the info Annal |
161 | 14 Feb 2008 @ 03:01 PST | UDA | Reply | Corelated Sub Queries | When 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... |
160 | 14 Feb 2008 @ 02:48 PST | Tools | Reply | Mload: Update duplicate rows | I 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. |