#DateForumTypeThreadPost
67108 May 2014 @ 05:29 PDTGeneralReplydifference between HASH INDEX and SINGLE TABLE JOIN INDEXDocumentation: They are both created for goOd performance. A hash index cannot have a partitioned primary index, but a single-table join index can. A hash index must have a primary index, but...
67008 May 2014 @ 04:33 PDTDatabaseReplySkew, amp and column selectionIt reminds me of this link. http://teradataforum.com/teradata/20061011_093633.htm  
66907 May 2014 @ 12:12 PDTDatabaseReplySlowness in Teradata systemSince it is urgent, a quick thought if they help you. Loads maybe high, number of users may increase.Check locks it may be while doing backup, who knows, hut locks(showlocks util) , blocke...
66806 May 2014 @ 09:52 PDTDatabaseReplyIdentifying Temporal Tables     Plz doubke check. I am on 14.10.   create set table retail.temp1(id integer, dob period(date) format 'YYYY-MM-DD');   SELECT * FROM DBC.CO...
66706 May 2014 @ 09:45 PDTGeneralReplySQL helpCan you try on bteq with this logic? Select  a. mtr_id from  table A Where   A.id  = STGtable. ID .if activitycount =... <> ........ then .goto  .label l123 sa...
66606 May 2014 @ 12:41 PDTDatabaseReplyIdentifying Temporal TablesHi Kishore_1, I am glad that your period data type problem is resolved. There are many functions  available in teradata temporal features. I am not able to see any indicator in any...
66501 May 2014 @ 09:43 PDTDatabaseReplyColumn encryptionOne way is udf or write your own code to encrypt and decrypt. Have heard about Protegrity cryptography and md5_udf but never used in any project.
66429 Apr 2014 @ 10:49 PDTDatabaseReplyPeriod data typeCan you try with SELECT your_period_data_type,BEGIN(your_period_data_type) from your_table; SELECT * FROM  your_table WHERE BEGIN(your_period_data_type) = DATE '2014-04-30'; SELECT ...
66329 Apr 2014 @ 05:40 PDTGeneralReplyDifference between Teradata utilitiesIt is Teradata Parallel Transporter wizard, where you can define job wizard. Give a try as a test.
66229 Apr 2014 @ 04:30 PDTGeneralReplyDifference between Teradata utilitiesDid you try with wizard? Source Type: Teradata table. Destination Type: Teradata Table.  
66128 Apr 2014 @ 11:56 PDTGeneralReplyDifference between Teradata utilities1. Yes you can load. Even using TPT wizard can be more handy, where you can choose Teradata table, File, ODBC, Oracle as source, you can define cols etc. You have option of Load, Update, Stream ope...
66028 Apr 2014 @ 12:52 PDTDatabaseReplyTD Version differencesFor ease of referrals , I keep few links. Will the below links  be helpful , since you are looking at high level? http://www.teradatamagazine.com/v11n04/Tech2Tech/Bold-Steps-Advance-Data...
65924 Apr 2014 @ 11:40 PDTDatabaseReplyTools to compare two teradata's DB and find the differencesI think you come from oracle background.The schema concept eg Oracle stores a schema object logically within a tablespace of the database . Here it is database.  You can just fine tune and t...
65822 Apr 2014 @ 11:22 PDTGeneralReplyConverting Oracle SQL*Loader scriptsI have never heard of any tool that converts sql loader control files to teradata scripts. You can replicate ctl files functionalities using tpt or fastload . Even if a tool exists also f...
65722 Apr 2014 @ 05:57 PDTTeradata ApplicationsReplyTable properties and utilities to load dataThis is a good read on checksum. http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/Database_Management/B035_1093_111A/ch09.028.24.html I have not experimented with various settin...
65618 Apr 2014 @ 03:59 PDTDatabaseReplyIdentify Set - Multiset Tables in TD 14Did you try with CheckOpt ,dbc.tables? Also you can get with these conditions: where tablekind = 't' and requesttext like '%create%' and requesttext like '% set%' No...
65518 Apr 2014 @ 01:57 PDTGeneralReplyConvertion from SQL Server to TeradataI think you have a binary timestamp in sql server. If so, then you can convert that in sql server query itself to string or date, then take it forward.  
65418 Apr 2014 @ 01:49 PDTGeneralReplyWhen we need to collect stats on tableUsually, collect stats is done at the end of load or collectively at the end of all loads. In real time big DWH projects, we collect stats only for important tables. In case, the architecture has w...
65318 Apr 2014 @ 01:28 PDTDatabaseReplyScemantic Layer in Teradata Data WarehouseI worked few projects where we built semantic layer on top of central or EDW or 3NFs. Semantic layer is more of aggregation. The design of this layer is when we understand more of what the reporti...
65215 Apr 2014 @ 12:38 PDTDatabaseReplyPartition Primary IndexYou need to know your data demography, size. Choose the partitioning columns, no. of partitioning expressions, no. of partitions level. You may  choose  range , case and in that check c...
65114 Apr 2014 @ 11:43 PDTDatabaseReplyDaily Increase in Space for Database ?Hi Nishant, Maybe you need to tweak a little. The link  below can be a good pointer. http://forums.teradata.com/forum/database/how-to-know-the-table-size-growthreduce-in-teradata Put in a u...
65014 Apr 2014 @ 09:34 PDTAnalyticsReplyREGEXP_SPLIT_TO_TABLE doesn't work oh!!!! Dieter, My release is 14.10.00.02. So I should get the latest release????
64914 Apr 2014 @ 07:48 PDTAnalyticsReplyREGEXP_SPLIT_TO_TABLE doesn't work Oops, a quick look for me also it does not work. But I remember one nice guy works a lot on regex function. Maybe if it helps your requirement. http://forums.teradata.com/forum/database/regular-e...
64814 Apr 2014 @ 03:38 PDTCloud ComputingTopicTeradata on Amazon RDSAnyone can pass an info if  Td is  configurable on Amazon RDS?  
64711 Apr 2014 @ 06:02 PDTAsterTopicTeradata Aster SQL-GR™I am looking at some detailed documents on SQL-GR since I am comparing with Neo4j. Can you please share any pointer for me? Thanks,

Pages