#DateForumTypeThreadPost
3018 Feb 2008 @ 04:08 PSTDatabaseReplyTeradata For Tranasactional applicationsIf teradata is used for OLTP,it should be a database that often do insert/delete operations, not updatealso, there should be bulks of data in/out , not bulks of piece of data in/out
2918 Feb 2008 @ 04:06 PSTDatabaseReplyHow to change CASE NOT SPECIFIC to CASE SPECIFIC for PI fieldsYou can't change PI after you have create the table, as it will cause the data to redistribute,the better way is to drop the table,If no more choice ,you can convert it in SQL, but it not the pref...
2825 Jan 2008 @ 04:22 PSTDatabaseReplyOracle to Teradata MigrationIt seems that you have to do it yourselfwe can only get it from bteq log.or you can use " case when "but i thought it will need extra spaces
2709 Jan 2008 @ 12:31 PSTDatabaseReplyDELETE ALL vs DELETEThere is difference between Delete and Delete all,Delete all will truncate the index table,while delete will maintain the index table,also i thought their should be difference in journals,in fact, ...
2609 Jan 2008 @ 12:00 PSTDatabaseReplyExtracting month from date as 'MMM'Yes,Bteq and SQL assistant may have different result of the same sql,Just because bteq use CLI and SQL Assistant use odbc, but if you use sql for etl, you'd better try sqls in bteq
2525 Dec 2007 @ 01:30 PSTDatabaseReplyTable Copywhen insert into new table ,it's just insert into index table, if not , index table need extra load
2407 Dec 2007 @ 12:58 PSTDatabaseReplyORDER BY clause within VIEWOrder by is not used in view clause(DML),I thought view is just a sql, and when you read data from view, if there is oder by , this will cause the data to redistribute, in fact , if you want the da...
2307 Dec 2007 @ 12:40 PSTDatabaseReplyPerformance tuning-2Madhavi, I strongly agree with Annal T,you must avoid useing the expression that will cause the SI doesn't work, it's a rule
2207 Dec 2007 @ 12:37 PSTDatabaseReplyHow to accomplish this in Teradatalock table for writeupdate table set key=valueselect max(col)+1 as value from tablerelease lock
2105 Dec 2007 @ 04:24 PSTDatabaseReplyPerformance tuning-2i saw you use date between xxxx and xxxxif this is a very big table, and you data distributed commonly by date,perhaps you may use PPI
2005 Dec 2007 @ 04:21 PSTDatabaseReplyPerformance tuning-2GPW_DATA.B01_BKP1.GPWB01_FILL_RPRT_Y <= DATE '2007-11-30') AND(GPW_DATA.B01_BKP1.GPWB01_FILL_RPRT_Y >= DATE '2007-11-01'))")this two, if you didn't use '=', no index will be used
1925 Jun 2007 @ 05:14 PDTDatabaseReply[HELP] Modify a column name that is also a NUPI Index...As for rename of attribute or other.i always think it's application layer's fault.if we use views right. we should put less care on whatit names, but what it names in view. to access data via view....
1831 May 2007 @ 09:50 PDTDatabaseReplySQL: Using COALESCE in subquerybtw:COALESECE and CASE is for different use,coalesce can only deal with null values, while case have more
1731 May 2007 @ 04:31 PDTJobsReplyTeradata Analyst Needed in Chicago, IL Strong SQL RequiredHi,Maggie I will be on trip to USA, Naperville,IL in the begining of July, can i do this job on my spare time :-)
1631 May 2007 @ 04:28 PDTDatabaseReplyPerformance of view containing a Union clauseunion will eliminate the duplicate rows and redistributionunion all won't,that's the difference
1531 May 2007 @ 04:24 PDTDatabaseReplyQuery Helpvolatile table need more priviledge than just create tables :-)
1431 May 2007 @ 04:11 PDTDatabaseReplyData Distribution SkewSELECT HASHAMP (HASHBUCKET (HASHROW (pi))), COUNT(*) count(*)from table group by 1 you should first make sure you choose the right PIAlso , perhaps 4000 is too little for Teradata, perhaps yo...
1331 May 2007 @ 04:06 PDTDatabaseReplySQL: Using COALESCE in subqueryyes, coalesce can be used in subquery but it was not suggested, Use coalesce in subqueries will not use the indexs.so you may first normalize your data before run the queries, and insert the normal...
1218 Apr 2007 @ 03:19 PDTDatabaseReplyChallenges of migration from oracle to TeradataAs PKPI, great effort should be done for Applications, not just Database.Also sql scripts should be cared especially when your sql doesn't follow ANSI :-)Terdata have a little difference from Oracl...
1118 Apr 2007 @ 02:58 PDTToolsReplyExport Import from one database to another.It's strongly suggested to use a temporary table for import . :-) in Teradata, fastload is to load data into temporary table , no destination table .if use arcmain, the former data in the table wi...
1013 Feb 2007 @ 12:26 PSTDatabaseReplyRecords vs Speed!you may use explain to see it :-)sometimes it was said that PE decides that when little amount of data , product join is much better than use merge join ,perhaps it's the case
913 Feb 2007 @ 12:21 PSTDatabaseReplyRunning bteq scripts through crontabsu - username -c "/a123b/scripts/abc.sh >> /a123b/scripts/hello1.log 2>&1 "As crontab is for system level, use user-root's environment :-) Hope may be useful .Years ago when i elt data ,met with t...
812 Feb 2007 @ 01:23 PSTDatabaseReplyAccessing Row Hash of a recordThanks Perter:-)I have gone home to look my books ,same results
709 Feb 2007 @ 03:48 PSTUDAReplyadvantages of teradata over other databasesTeradata is not as open as Oracle in Tech.many key tech is still under the control of Teradata PS,and Teradata is for enterprise application, not as widely used as Oracle or Sybase
608 Feb 2007 @ 11:39 PSTDatabaseReplyAccessing Row Hash of a recordselect rowhash( primary index of the record) not very sure about it ,i seldom use this function,perhaps you may refer to Teradata Trainning material described very clearly in it

Pages