#DateForumTypeThreadPost
112129 Oct 2014 @ 08:28 PDTToolsReplyBTEQ export CSV issueTry to cast each field. This example may help you. https://forums.teradata.com/forum/database/help-needed-in-bteq-export
112029 Oct 2014 @ 07:31 PDTGeneralReplyIs Teradata good for Operational Online ApplicationsI did not work with Java team in one project,I had worked before . But I never heard any complaint from there. I never coded online applications with Teradata. Just my curiosity.Are they using MyB...
111929 Oct 2014 @ 01:32 PDTDatabaseReplyDate field behaving different in different environmentEven if you choose/set as below? SET SESSION DATEFORM = ANSIDATE                 = INTEGERDATE  
111828 Oct 2014 @ 11:04 PDTGeneralReplyHow to check any STATS being used by a query/queries or not?  Carrie's blog---STATSUSAGE, XMLPLAN......if it helps http://developer.teradata.com/blog/carrie/2013/12/easing-into-using-the-new-autostats-feature
111728 Oct 2014 @ 07:08 PDTDatabaseReplyCpu and io skew -99%Maybe you can share the query? Joins of tables, if can be tweaked meeting the end requirements. Also, if logics can be broken up VT, GTT. How about temporal features too? I see date  comparis...
111628 Oct 2014 @ 06:54 PDTGeneralReplywhat are the drawbacks by using join index table?You could have read the doc :)   Join indexes can be expensive to maintain.  Each time a join-indexed base table column is updated or deleted, the corresponding join index table ...
111528 Oct 2014 @ 06:43 PDTGeneralReplyIf we create a 32 secondary indexes on table what might be the performanceCreating a secondary index causes the system to build a subtable to contain its index rows, thus adding another set of rows that requires updating each time a table row is inserted, deleted, or upd...
111427 Oct 2014 @ 11:37 PDTTrainingReplyPointers for TD CertificationMy suggestion is , based on the content and context of certification and referring to the release notes, you go specific to the features of utilities, tools..db in detail. The questions may not be ...
111327 Oct 2014 @ 11:16 PDTDatabaseReplyCpu and io skew -99%Initial thought: Without much info,just the explain, a quick glance, looks like your OR clause. How about replacing with IN? Modeling is one part , where I see that should have been taken care w...
111227 Oct 2014 @ 10:10 PDTData ModelingReplyCasting integers....Do you mean? CAST(BlgPrdSvcCd as integer) and not as CAST(BlgPrdSvcCd as int)
111127 Oct 2014 @ 10:10 PDTDatabaseReplyHadoop threat to data warehouse vendors My opinion: Not at all a threat. Rather, it is creates a plethora of opportunities.There are tens of thousands of writes-up on the web. But those who made comments, may not have gone deep or...
111027 Oct 2014 @ 05:29 PDTDatabaseReplywrite SQL UDF in TeradataThat is what they are made of. Love unix and C programming too but I choose java here.For example, there are few udfs I made in java, say like search for a pattern. Compile that java code. Create a...
110927 Oct 2014 @ 03:24 PDTDatabaseReplywrite SQL UDF in TeradataI think it is better for your case to write in java or c or c++. http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1147_111A/ch04.059.06.html, even examples are...
110826 Oct 2014 @ 09:27 PDTDatabaseReplyTSET CollectionMaybe you can try with GTT. However, the materialized contents cannot be shared across. It may or may not be accurate as per your reqt or you can simulate the same thing of a VT :)
110723 Oct 2014 @ 09:43 PDTGeneralReplyNeed Help with QueryNeed to be careful with data type:   select id,id1, max(coalesce(key1,0))over(partition by id,id1 order by id,id1 rows between unbounded preceding and unbounded following) k1,max(coalesce(...
110623 Oct 2014 @ 08:38 PDTDatabaseReplyLoad Different DATE formats into TeradataIf your target is varchar, it can be in any format. In some cases, you need to cast.
110523 Oct 2014 @ 08:05 PDTGeneralReplysetting a parameter inside of a bteq scriptIn Unix/linux, you can use say for example : export DB_NAME=DB1 inside the script
110422 Oct 2014 @ 11:46 PDTToolsReplyHiding password in mload scriptYou can read this article: http://developer.teradata.com/tools/articles/introducing-teradata-wallet
110322 Oct 2014 @ 09:17 PDTDatabaseReplyTD_UNPIVOT throwing error: SELECT Failed. [9134] TD_UNPIVOT_CONTRACT; Help is confusingYou can work out with query. You can test  with  sample data of what you have and what you want to achieve, you can tweak.
110222 Oct 2014 @ 08:33 PDTGeneralReplyOReplace vs. Case StatementYou can check this and see, implementing with your case when: select regexp_replace('10=Very Satisfied','[^0-9]+','',1,0,'i')
110122 Oct 2014 @ 06:48 PDTGeneralReplyOReplace vs. Case StatementI am not clear with what you want. Can't assume much :).However, you can use an oreplace within another oreplace.. You can use oreplace in conjuction with case stmt  based on your requirem...
110022 Oct 2014 @ 01:05 PDTDatabaseReplyAny good Teradata MaterialI think you can post under Training :) You can go through this link and directions are provided with hyperlinks. http://forums.teradata.com/forum/training/terdata-certification-in-india
109921 Oct 2014 @ 07:42 PDTDatabaseReplyTeradata query tunningMy suggestion is to tweak at BO side, join properties. Try to replace IN with = wherever possible. Think of how you can recode this : IN ('-ALL-')  OR  '-ALL-' IN (&#...
109820 Oct 2014 @ 11:57 PDTDatabaseReply Load utilities Limit in TASMHi Sandeep, The admin will inform you. Cheers, Raja
109720 Oct 2014 @ 11:36 PDTDatabaseReplyHow can i find actul uncompress size of BLC Compress tableFerret's commands aplenty, showblocks, showcompress......estimate.... Need to balance the IO and CPU :). If you need to see the size of table, then dbc.tablesize.

Pages