#DateForumTypeThreadPost
34421 Dec 2013 @ 01:47 PSTDatabaseReplyDoes one need unicode compression in Tredata 14.0Hi, AFAIK, TRANSUNICODETOUTF8 is a TD 13.10 enhancement. These functions are also present in TD 14.0 and used to compress and decomress Unicode. I have found the below reference how Unicode i...
34320 Dec 2013 @ 09:11 PSTDatabaseReplyFinding the table size alone?Sorry, I was thinking with respect to physical database design. 
34220 Dec 2013 @ 03:40 PSTDatabaseReplyFinding the table size alone?Hi Barani, You can alculate a row size as follows: Logical size = SUM(Bytes for fixed length columns) + SUM(Byte for Variable Lenght Columns) Physical size = Logical Size + 14 Bytes overhead + P...
34119 Dec 2013 @ 11:01 PSTDatabaseReplyIndex Cocepts in TeradataHi Ratnam, Basically these three are join processing strategies used by Teradata, and decided by the oprimizer based on number of factors. I think they are not availbel for the developer to choose...
34018 Dec 2013 @ 10:07 PSTUDAReplywhy should we use SET table ?Yes, as long as the table is set and index is non unique the duplicate row check will be performed. The table is empty initially but with the insertion of rows, the table will no longer be empty an...
33918 Dec 2013 @ 09:05 PSTUDAReplywhy should we use SET table ?Hi Suhail, You question is a little bit ambigous, but if you have a NUPI defined on a SET table, the duplicate row check will be performed.  You can avoid duplicate row check by either defin...
33818 Dec 2013 @ 08:55 PSTDatabaseReplySpool space issueHI, If you are talking about the sequence of joins execution, Teradata optmizer decides how to and in which sequence process the joins.  In order to avoid spool space problem you can check a...
33718 Dec 2013 @ 08:42 PSTDatabaseReplyIndex Cocepts in TeradataHi Ratnam, May I know the joins you want to compare? Teradata has different join processing techniques chosen by the optimzer at run time based upon the multiple factors. These factors can be ta...
33618 Dec 2013 @ 08:39 PSTTrainingReplyRegarding Certification Exams - Pass %Hi, The number of questions are 75. and there passing % is not disclosed yet, But usually passing % in TD exams is 80%.  
33517 Dec 2013 @ 11:43 PSTTeradata StudioReplyPlease provide more informaiton on Teradata studio and how we use in real time.You can also visit this URL to choose the right product for your client: http://developer.teradata.com/tools/articles/teradata-studio-products-choosing-the-right-client-tool  
33417 Dec 2013 @ 11:29 PSTTeradata StudioReplyPlease provide more informaiton on Teradata studio and how we use in real time.Hi, You can get a plenty of information about TD Studio from this article http://developer.teradata.com/tools/articles/teradata-studio  
33317 Dec 2013 @ 10:24 PSTToolsReplyError while loading data from teradata to SQL Server - TPT registry key cannot be openedHi, So the conclusion is the Connectors v1.2 version is not supported with TD 14, but supported with SSIS 2008. and Connectors v2.0 version is supported with TD 14 but for that you will...
33217 Dec 2013 @ 11:47 PSTToolsReplyError while loading data from teradata to SQL Server - TPT registry key cannot be openedHi, It looks Ok. What I feel is that your Microsoft® Connectors v1.2 for Oracle and Teradata version is not supported with TD 14. Go to the following link and get the updated drivers. I ...
33117 Dec 2013 @ 11:42 PSTDatabaseReplyjoining two tables using SUBSTRHi, The following thread will help you to construct a solution, you can get and insert these values into a temp table and then join on the basis of these values. http://forums.teradata.com/forum/...
33017 Dec 2013 @ 10:36 PSTToolsReplyStandard File Extensions for Teradata Tools ScriptsHi, the use of .txt for TD scripts is not a standard, although it can be used. In one of my projects we used the following extention: Bteq: .SQL FastLoad: .fld Mload: .mld TPT: .TPT One other...
32917 Dec 2013 @ 10:26 PSTToolsReplyError while loading data from teradata to SQL Server - TPT registry key cannot be openedI think I am getting your problem, You need to go to the Computer properties, go to advanced proprties, go to environment variables, and within system variables go to the Path variable. copy i...
32817 Dec 2013 @ 04:19 PSTDatabaseReplyError in update statementHI, Try this: UPDATE CUST_T FROM (SELECT A.CUST_ID,A.CUST_DT FROM CUST_T B INNER JOIN CUST__HIER A ON B.LAST_CUST_ID = A.CUST_ID) UPD1 SET CASE WHEN IMMED_CUST_DT = '9999-12-31'...
32717 Dec 2013 @ 12:41 PSTToolsReplyBTEQ login help-LDAP and kshYou can see the following blog: http://developer.teradata.com/connectivity/articles/logging-on-teradata-database-sessions-via-bteq  
32616 Dec 2013 @ 11:18 PSTDatabaseReplyUsage of Join indexes?Nishant, I believe within Teradata you have a universe of optimizations. There are plenty of ways avaialble to optimize BTEQ for loading purposes. You can start optimizations from your SQL SELECT...
32516 Dec 2013 @ 10:34 PSTToolsReplyError while loading data from teradata to SQL Server - TPT registry key cannot be openedHi, Can you please try the following: Run you BIDS as administrator and then give it a test, I am sure this will solve the issue. The second thing you can is to go to Environment variables, and ...
32416 Dec 2013 @ 10:30 PSTDatabaseReplyUsage of Join indexes?Nishant, You have made a great explaination. Yes this is a good methodology.  
32316 Dec 2013 @ 11:57 PSTGeneralReplyPPI - Secondary IndexesHi Cheeli, Secondary indexes are used sometimes to improve access over a PPI table. When you can not define a SI on PI, for example in case of NUPI, if your query contains condition on partition c...
32216 Dec 2013 @ 11:51 PSTDatabaseReplyUsage of Join indexes?Hi Nishant, a very interesting question, well, there are lot of trade offs when you are deciding about physical implementation alternativs. I beleive when you go for Join indexes, you will have to...
32116 Dec 2013 @ 11:35 PSTAnalyticsReplyFast Load Vs MultiloadHi San,  Sorry if my question is not clear, In fact you wrote that the scenario is ideal for Fastload, thats why I deduced you know much about these utilities.  Ulrich has explained wha...
32016 Dec 2013 @ 11:31 PSTTeradata ApplicationsReplyLimit on a tableHi San, Can you please elaborate the scenario? You have two tables, Tab1 can hold only 5 million rows? and what is the benchmark for more old data? and what is the source? is there any flag ...

Pages