#DateForumTypeThreadPost
44419 Feb 2014 @ 11:41 PSTDatabaseReplyRegular Expression On Teradata 14.0Nice post Satyaki, As Adeel advised, you should publish it on Teradata Blogs :)  
44319 Feb 2014 @ 11:27 PSTDatabaseReplyDelete table from within SSISHi Richard, That is quite simple, add an SQL task to the data flow, and within SQL wizard, add connection information to Teradata, and write down the query:"DELETE <Database Name>.<T...
44218 Feb 2014 @ 09:36 PSTToolsReplySELECT statement in a TPT EXPORT scriptHi, You can enter a tab to the left of each line, or you can re-write it as follows: VARCHAR SelectStmt     = ' seleSELECT     c1,c2, CASE WHEN c3 IS ...
44118 Feb 2014 @ 09:30 PSTGeneralReplyerror: The format or data contains a bad characterHow do you think you can subtract integer from string? substr(a13.FiscalWeekID,1,4) -1 You can cast it to integer then perform subtraction. CAST(substr(a13.FiscalWeekID,1,4) AS INTEGER) -1 &nbs...
44018 Feb 2014 @ 09:24 PSTDatabaseReplySSIS and Global Temp TablesRichard, Global temporary table base definition is stored in data dictionary. When you create a GTT, an instance of this base definition is created against the session. Temporary table instance wi...
43918 Feb 2014 @ 02:51 PSTDatabaseReplyHow to find AMP numbe using Row-Hash value?Sri, The first 16 or 20 bits are used to find the proper amp from the hash map, but the full 32 bit row hash is stored within the row, and is used in row retrieval.   
43817 Feb 2014 @ 11:59 PSTDatabaseReplyHash Index and Single Table Join Indexhere we go: 1- PI value is passed to a hashing algorithm and a 32 bit hash number is generated, this number is simply a mathematicaly blended value to be used to assign proper amps. 2- in all nor...
43717 Feb 2014 @ 11:44 PSTDatabaseReplyHashmap I agree with Sri, if the there is huge number of rows with small hash map, hashing would not stop, rather hash collsion will occure. A 32 bit uniqueness values is used to differentiate between the ...
43611 Feb 2014 @ 11:41 PSTCloud ComputingReplyHow do I get TTU to work with Teradata Express for VMware?Well,  it is quite simple, just add the ODBC entry for the Vmware machine on windows machine and you will be able to connect to the database.  
43511 Feb 2014 @ 05:11 PSTDatabaseReplyhow to get decimal value with no roundingHere are similar threads that will help you: http://forums.teradata.com/forum/database/truncate-a-decimal-field-without-rounding http://forums.teradata.com/forum/database/rounding-down-decimals ...
43411 Feb 2014 @ 05:09 PSTDatabaseReplyhow Upper() and Lower() functions work in TeradataHi, By default Teradata is not case sensitive, so it will treat Abc = ABC, While in you statement you are explicitly converting one string to upper and one string to lower, you should cast them to...
43311 Feb 2014 @ 02:34 PSTDatabaseReplyCheck Case Statement NULLHi, where col1=(case when :col1='xyz' OR :col1 is null then 'xyz' else NULL end)  
43211 Feb 2014 @ 02:29 PSTCloud ComputingReplyUnder WinXP Pro SP3, is installing > 4 GB RAM useful for running Teradata Express for VMware?The guest OS will be using portion of RAM from the HOST memmory. AFAIK, if the host windows XP is not using 4 GB, the guest will not be able to use extra RAM.  
43111 Feb 2014 @ 02:22 PSTDatabaseReplyGROUP BY Processing in TD 14The queries will pull the same result but there is processing difference between these two queries. Distinct will first sort and then eliminate duplicates, while group by do not sort. So group by i...
43011 Feb 2014 @ 02:20 PSTDatabaseReplyExport from SQL Server to Teradata Temp tablesVasu, A global Temporary table is a temporary table that uses temporary space for the storage. A base definition of the table is stored in the data dictionary, an instance of this table is created...
42906 Feb 2014 @ 10:34 PSTDatabaseReplyRanking the values ignoring duplicatesHi, You can use dense rank function to get this output. http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1145_111A/User-Defined_Functions.093.48.html  
42806 Feb 2014 @ 10:32 PSTDatabaseReplyTD Newbie: help needed to Convert rows to a columnThese two threads contain the similar solution, Hope it will help you. http://forums.teradata.com/forum/database/need-to-convert-rows-to-columns http://forums.teradata.com/forum/database/transpos...
42706 Feb 2014 @ 03:02 PSTDatabaseReplyExport from SQL Server to Teradata Temp tablesCan you please also tell how much data do you have to process?  
42606 Feb 2014 @ 03:01 PSTDatabaseReplyExport from SQL Server to Teradata Temp tablesRichard,   Whats the issue you are facing with SSIS?     
42505 Feb 2014 @ 09:39 PSTDatabaseReplyUse of NOT IN for a fact joinI think you can convert this subquery to a set operation using EXCEPT Set operator. It will improve a lot of performance.   
42404 Feb 2014 @ 02:42 PSTDatabaseReplyQuestion regarding FastloadHere you go: http://www.info.teradata.com/templates/eSrchResults.cfm?prodline=&txtpid=&txtrelno=&txtttlkywrd=TTU14.10&rdsort=Title&srtord=Asc&wNew=True&nm=Teradata+Tool...
42303 Feb 2014 @ 12:15 PSTDatabaseReplyNoPINOPI tables use an internal random row hash generator, Rows are assigned to the amps according the this randomly generated row hash.   Rows are appended at the end of each table, so no s...
42202 Feb 2014 @ 12:58 PSTDatabaseReplyFormatting CURRENT_TIMESTAMPAdeel,   I have a question, do we need to cast it to varchar while inserting through ODBC ? Or it is only required for display purpose?  
42102 Feb 2014 @ 12:54 PSTDatabaseReplySelection of Primary indexHi Nilesh, While choosing a PI, you always have to balance between the distribution and access. Some columns will give you optimal distribution while some will provide optimal access performance. ...
42030 Jan 2014 @ 10:30 PSTToolsReplyTeradata SQL Assistant 13.10 (ODBC version) - DownloadBaala,   The older version have been removed from download site. I think you can use TTU 14, it will serve the same purpose as TTU13. Is there any specific need to use TTU 13?  

Pages