#DateForumTypeThreadPost
6710 Jun 2009 @ 09:46 PDTDatabaseTopicDuplicate Unique Prime key error in Identity column TableHi,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...
6613 Apr 2009 @ 11:51 PDTDatabaseReplyRegarding Performance issue while increasing the no of Concurrent usersIts 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
6513 Apr 2009 @ 10:21 PDTDatabaseTopicRegarding Performance issue while increasing the no of Concurrent usersHi 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...
6422 Mar 2009 @ 10:16 PDTDatabaseTopicAJI usage in SQLs which have subqueriesHi 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 ...
6316 Mar 2009 @ 01:01 PDTDatabaseTopicRegarding Join Index usage when reporting SQLs use ViewsHi 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...
6218 Dec 2008 @ 11:08 PSTToolsTopicLoading multiple lines in input files into a single record using FastloadHi,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...
6115 Dec 2008 @ 11:36 PSTDatabaseReplyRegarding Identity numbers generation by PE/AMPSThanks 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 ...
6014 Dec 2008 @ 12:59 PSTDatabaseTopicRegarding Identity numbers generation by PE/AMPSHi 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...
5930 Jul 2008 @ 08:36 PDTDatabaseReplyInteger Vs Varchar in joins - Performance ImpactHi 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...
5830 Jul 2008 @ 03:26 PDTDatabaseTopicInteger Vs Varchar in joins - Performance ImpactHi,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(...
5719 Jun 2008 @ 10:20 PDTToolsReplyOracle to teradata using informaticathe 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...
5619 Jun 2008 @ 10:17 PDTToolsReplyOracle to teradata using informaticaYes. 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...
5513 Feb 2008 @ 06:42 PSTToolsReplyteradata profilerHi Leo,The document available at http://www.teradata.com/t/page/120726/index.htmlgives the basic details on Teradata Profiler.Regards,Annal T
5424 Dec 2007 @ 04:23 PSTDatabaseReplyTable CopyYou 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...
5317 Dec 2007 @ 01:04 PSTDatabaseReplyspool tables Primary Indexes and confidenceConfidence 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 ...
5217 Dec 2007 @ 12:49 PSTDatabaseReplyDatablocksize and FreespaceA 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...
5117 Dec 2007 @ 02:05 PSTDatabaseReplyReg: Partitioned Primary IndexIn 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...
5016 Dec 2007 @ 06:56 PSTDatabaseReplyRegarding 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
4914 Dec 2007 @ 05:26 PSTDatabaseTopicRegarding 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 ...
4806 Dec 2007 @ 11:02 PSTDatabaseReplyPerformance tuning-2Hi 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...
4729 Nov 2007 @ 12:04 PSTToolsReplyTrying to understand the Secondary IndexHi 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...
4628 Nov 2007 @ 02:15 PSTDatabaseReplyORDER BY clause within VIEWOne 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...
4516 Nov 2007 @ 11:26 PSTToolsReplyInformatica 7.1.3 and Teradata V2R6Bcos 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...
4415 Nov 2007 @ 08:32 PSTDatabaseReplyGaps in values for identity columnsHi 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 ...
4314 Nov 2007 @ 04:59 PSTDatabaseReplyNode Memory optimizationI'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...

Pages