67 | 10 Jun 2009 @ 09:46 PDT | Database | Topic | Duplicate Unique Prime key error in Identity column Table | Hi,I'm getting duplicate Prime key error while loading into a Table with Identity column(which is defined as the UPI)Since the number is autogenerated i'm not sure why this happens(I have also defi... |
66 | 13 Apr 2009 @ 11:51 PDT | Database | Reply | Regarding Performance issue while increasing the no of Concurrent users | Its a 1 Node 10 Amp systemBut as said earlier no other application is running on the Server and System resourcesare completely available to our application.Regards,Annal T |
65 | 13 Apr 2009 @ 10:21 PDT | Database | Topic | Regarding Performance issue while increasing the no of Concurrent users | Hi All,We are facing severe performance issues while increasing the concurrent users accessing the Reports.(Queries that run in few seconds takes minutes to run if we increase the users from 1 to 5... |
64 | 22 Mar 2009 @ 10:16 PDT | Database | Topic | AJI usage in SQLs which have subqueries | Hi All,I observed the following in my AJI testing and would like to know if this is expected behaviour.If yes what could be the reason for it and if there are any workaround to make this query use ... |
63 | 16 Mar 2009 @ 01:01 PDT | Database | Topic | Regarding Join Index usage when reporting SQLs use Views | Hi All,I'm trying creating a Join index to tune a reporting SQL.Reporting SQL accesses only the views and say i have 3 views V1, V2, V3Here V1 corresponds to the largest table and is a simple "Sele... |
62 | 18 Dec 2008 @ 11:08 PST | Tools | Topic | Loading multiple lines in input files into a single record using Fastload | Hi,By default Fastload treats each line in input file as one record.Is it possible to configure Fastload, so that we can define a special character and Fastloadwould read everything until that spec... |
61 | 15 Dec 2008 @ 11:36 PST | Database | Reply | Regarding Identity numbers generation by PE/AMPS | Thanks for the info!!!I'm fine with the gaps.I wanted to know if at all there would be any scenario where we would run out of numberseven if we have not inserted the allowable count of records due ... |
60 | 14 Dec 2008 @ 12:59 PST | Database | Topic | Regarding Identity numbers generation by PE/AMPS | Hi all,I have some doubts on Identity numbers generated by PE/AMPs.Say my Identity column is a smallint and say i define the start and end number as 1 to 32000and my Batch generation number is 1000... |
59 | 30 Jul 2008 @ 08:36 PDT | Database | Reply | Integer Vs Varchar in joins - Performance Impact | Hi All,Thanks for the inputs!!!I'm not considering scenarios where i would be using substr or any concatenation etc.(Other factors like Data volume, any kind of indexes created can also be consider... |
58 | 30 Jul 2008 @ 03:26 PDT | Database | Topic | Integer Vs Varchar in joins - Performance Impact | Hi,I would like to know if there would be any performance impact when we join based on Varchar columnsand when we join based on Integer columns.Case 1: Table1 and Table 2 has EmployeeId as varchar(... |
57 | 19 Jun 2008 @ 10:20 PDT | Tools | Reply | Oracle to teradata using informatica | the path didnt appear in the previous post because of the usage of less than operatorfile name is\\.\Pipe\outputfilenamewhere \\.\Pipe is the windows special path where all the pipes will be create... |
56 | 19 Jun 2008 @ 10:17 PDT | Tools | Reply | Oracle to teradata using informatica | Yes. We can use Pipe option for this.While configuring loader connection in Infa uncheck the "IsStage" option andChange the Checkpoint value to 0ANDIn the Loader Script(Control File gen by Infa) gi... |
55 | 13 Feb 2008 @ 06:42 PST | Tools | Reply | teradata profiler | Hi Leo,The document available at http://www.teradata.com/t/page/120726/index.htmlgives the basic details on Teradata Profiler.Regards,Annal T |
54 | 24 Dec 2007 @ 04:23 PST | Database | Reply | Table Copy | You could run a Show table command to get the exact DDL, then change char(8) to char(10) and thenrun the ddl script to create the table.Then you can run an insert select command to insert data into... |
53 | 17 Dec 2007 @ 01:04 PST | Database | Reply | spool tables Primary Indexes and confidence | Confidence levels of spool files would be higher if statistics are collected on the columns of the base tables from which the spool file is created.Statistics can be collected on the columns shown ... |
52 | 17 Dec 2007 @ 12:49 PST | Database | Reply | Datablocksize and Freespace | A Datablock is a unit of space allocated to Table(not shared between tables)Datablocksize gives the maximum permitted size of the block that will be allocated for the table.Freespace percent is the... |
51 | 17 Dec 2007 @ 02:05 PST | Database | Reply | Reg: Partitioned Primary Index | In your example when we try to insert a row, TD uses c1,c2,c3 to find the AMPand C2 to find the partition in that AMP and scans just that partition alone to check for duplicates.Why would we go for... |
50 | 16 Dec 2007 @ 06:56 PST | Database | Reply | Regarding TPerf and Perf-C !!! | Hi Leo,The link was useful.It gave a good basic intro to T Perf.Thanks to james and to you for providing the link !!!Regards,Annal T |
49 | 14 Dec 2007 @ 05:26 PST | Database | Topic | Regarding TPerf and Perf-C !!! | Hi, I would like to know more about the parameters TPerf and Perf-C.Got a little info in one of the articles in Teradata magazine.But couldnt find more details about these in the magazine or Admin ... |
48 | 06 Dec 2007 @ 11:02 PST | Database | Reply | Performance tuning-2 | Hi Madhavi, The following options can be tried out. But activities like creating index, collecting stats etc are resource intensive and comes with a cost. So use them judiciously(i.e if they give y... |
47 | 29 Nov 2007 @ 12:04 PST | Tools | Reply | Trying to understand the Secondary Index | Hi Dieter,Kindly let me know what you mean by this statement"Nevertheless single AMP access is possible for both USI/NUSI when it's based on the tables PI, then the optimizer knows about that"Regar... |
46 | 28 Nov 2007 @ 02:15 PST | Database | Reply | ORDER BY clause within VIEW | One can specify the Order by Clause only when we use the Top n Option in the select query to select the top n rows from the base table.(This info is available in the SQL Data Definition PDF)Regards... |
45 | 16 Nov 2007 @ 11:26 PST | Tools | Reply | Informatica 7.1.3 and Teradata V2R6 | Bcos TD utilities are built around Teradata Architecture and makes use of it in the best possible way, which WAS not the case with Informatica.But Informatica now does provides you the option to us... |
44 | 15 Nov 2007 @ 08:32 PST | Database | Reply | Gaps in values for identity columns | Hi Rajan,There can be gaps in sequences. In your case i think the system first generated value for the first column before checking the validity of second column value. (Which failed and resulted ... |
43 | 14 Nov 2007 @ 04:59 PST | Database | Reply | Node Memory optimization | I'm not a TD DBA, so i dont have real time experience on handling memory issues.But Please check the following link where Carrie has answered a question on issues with memory.http://www.teradata.co... |