#DateForumTypeThreadPost
31916 Dec 2013 @ 11:27 PSTAnalyticsReplyFast Load Vs MultiloadHi San, In your first line "In case of ideal senario for FastLoad why do we consider Fastload instead of Multiload" You know that the scenario is ideal for fastload, then what made you t...
31816 Dec 2013 @ 03:44 PSTDatabaseReplyExtractin a QUERY TEXT from a Column and using this output we need to insert the data into another table.Hi, How many rows / Select statements are there in QUERY_TXT?  Do you have to repeat this BTEQ for all the rows in QUERY_TXT?  
31715 Dec 2013 @ 11:07 PSTDatabaseReplySubstring Error?Hi, There are two syntax available for substring: SUBSTRING( STRING FROM FOR) SUBSTR(STRING , START_INDEX , LENGTH) So if you are using substring you must specify FROM and FOR instead of comma....
31615 Dec 2013 @ 11:01 PSTToolsReplyAlmost databases can't list in my Data Source ExplorerHi, Which tool you are talking about? If you are talking about studio, then the following link might help you: http://forums.teradata.com/forum/database/why-i-do-not-see-all-the-databases-in-ter...
31515 Dec 2013 @ 10:06 PSTDatabaseReplyWhy explain plan is so offHi, You do not have any stats collected on any table, thats the thing misleading the optimizer. The optimizer always require stats on table to give accurate estimates, else it may give unrealistic...
31414 Dec 2013 @ 11:52 PSTDatabaseReplyset table with sum vs multiset with no sumHi, You have not provided information about the indexes, the second confusing thing is whether you are trying to insert the individual rows, or you need to insert aggregates? What I suppose is you...
31314 Dec 2013 @ 11:43 PSTGeneralReplyGROUP BY CUBE or ROLLUP how to use it?Hi Millan, The first thing is what is a cube? A cube is simply used for multidimentional processing. it is also called OLAP Cube, and Teradata has extended its Group by cluase to easily handle all...
31214 Dec 2013 @ 11:19 PSTGeneralReplyTeradata Certification re-take policyHi, You have provided answer in the second line. you can take a retake after 21 days, and yes you will have to pay the full fee for retake exam :)  
31113 Dec 2013 @ 09:31 PSTDatabaseReplyCollect stats doubtHi Goldminer, Thank you for sharing your thoughts, But this limitation has been eliminated in TD 14. Now the multicolumn stats are not truncated :)  
31013 Dec 2013 @ 04:36 PSTDatabaseReplyNumeric Overflow ErrorHi, What do you mean by records of length 16? is it a numeric or character value? Can you please provide a sample value ?  
30912 Dec 2013 @ 11:46 PSTDatabaseReplyCollect stats doubtTiger, It is just a recomendation I found in TD docs. It is good that you are getting the same estimates in both cases, But It is recomeneded that when you are using the columns together in equali...
30812 Dec 2013 @ 11:38 PSTDatabaseReplyHow to grant UPDATE to DBC on DBC.IDCol Tables?Kawish, Can you please explain what do you want to achieve, as discussed in the post you mentioned, you can either recycle the Identity, Or you can use START WITH, INCREMENT BY, MINMUM VALUE, ...
30712 Dec 2013 @ 11:03 PSTAnalyticsReplysecondary indexSan, Yes sure, keep posting your queries, it is a good source of learning for others as well :)  
30612 Dec 2013 @ 10:59 PSTAnalyticsReplyWhile we add New AMPsan, The simple answer is:  RowID(010101..001001)=ROWHASH(010101 --- AMP9)+(001001 ---uniqueness value) as a result of reconfiguration the hashmap is changed, the same ROWHASH passed to the...
30512 Dec 2013 @ 10:55 PSTDatabaseReplyCollect stats doubtHi Tiger, There are two recomnedations to collect multicolumn stats: When the columns are being used in condition or in join condition together When there is a NUSI defined comprisin...
30412 Dec 2013 @ 10:40 PSTAnalyticsReplysecondary indexHi San, a. a SI subtable is distributed just like data table to all amps. and it is not the same table, it is distributed based on row hash. b. In case of NUSI, the PE sends a broadcast message t...
30312 Dec 2013 @ 10:01 PSTAnalyticsReplyWhile we add New AMPHi Sankalp, RowID = ROW HASH + UNIQUENESS VALUE Row hash is detemined by the PI value, So when ever a reconfiguration occurs, the rows are just moved to the new amps because the Row Hash in the n...
30211 Dec 2013 @ 11:40 PSTGeneralReplyFastload Error Table 2Hi, when the fastload receives duplicate values for the UPI, it inserts the UPI violation rows into error table. this error table is created each time, but dropped only if there is no UPI violatio...
30111 Dec 2013 @ 09:47 PSTGeneralReplySame query taking different CPU TIME, RESPONSE TIMEHi Raj, The response and throughput depends upon a number of factors, at times you might have different workloads running, that might cause different response time for the same query.  
30011 Dec 2013 @ 10:58 PSTDatabaseReplySkewed QueryHi, Can you please share the definitions of both the source tables? Or at least the Primary index information?  Also share the row count of both the tables.   
29911 Dec 2013 @ 10:39 PSTDatabaseReplyBteq script - error handling not working, need helpHi, You can use the below template to handle errors, while activity count is writted to log file based on the type of statement (Insert, Update, Delete) SELECT 'STARTDTTM' AS A, CURRENT...
29811 Dec 2013 @ 10:32 PSTAnalyticsReplyjoin indicesHi Sankalp, I do not beleive that a query can be forced to use join index, as the use of join index is a processing decision made by the optimizer  based on statistics. The only way is to col...
29710 Dec 2013 @ 11:55 PSTDatabaseReplySQL to transpose (row to column) any level (nth level) of dataHi Koushik, There is already a thread with this topic, you can consult that: http://forums.teradata.com/forum/database/transpose-rows-to-columns-0  
29610 Dec 2013 @ 11:01 PSTAnalyticsReplyWhile we add New AMPYes sure, you can read about reconfiguration and a lot more at the link below: http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/Utilities/B035_1180_111A/Reconfig.15.04.html &nbs...
29510 Dec 2013 @ 10:49 PSTToolsReplySQL Assistant 12.0Hi Surabhi, if you have installed TD Express 13.0, even then you can install latest TTU available on the below link and it will be working fine. I am also using this. http://downloads.teradata.co...

Pages