All forum activity

#DateUserForumTypeThreadPost
59223 Mar 2006 @ 05:31 PSTozi_wozzyAnalyticsTopicscript queryHi guysI have a slightly generic query. I have a table with actual sales and budget per week for the whole year, and another table which holds calender information, which I link my first table to w...
59123 Mar 2006 @ 02:43 PSTTD_ArchToolsReplyTPump vs MLoadFound an informative read at http://www.teradata.com/teradataForum/shwmessage.aspx?ForumID=10&MessageID=3566
59023 Mar 2006 @ 02:12 PSTTD_ArchToolsTopicTPump vs MLoadHi All,Till date I have just been using Mload. But at the moment, i am considering the implications of using TPump for a new data load of approximately 75 million rows per day. The TD Manual on TPu...
58922 Mar 2006 @ 08:46 PSTfishmoDatabaseTopicDates and Foreign KeysWhat is the generally recognized approach when dealing with business dates (Order date, Ship date) where they'll be used in conjunction with a date dimension table (for adhoc queries)? More specif...
58822 Mar 2006 @ 05:58 PSTKksJobsReplyTeradata Professional needed (South Africa)Hi,mail_ids do not matters as long as the person applying is genuine
58722 Mar 2006 @ 03:28 PSTdnoethDatabaseReplyselect first N recordsNon-Standard TOP syntax is supported since V2R6...It can be replaced by Standard SQL RANK/PERCENT_RANK/ROW_NUMBER in most cases.It's only useful for a "select top ... * from table" without any orde...
58622 Mar 2006 @ 01:30 PSTdivyasrheeUDAReplyDefault spacesThanks a lot.
58522 Mar 2006 @ 01:26 PSTrlaskarUDATopicSyntax to create surrogate keys in a tableI was trying to create a table with surrogate keys defined.
58422 Mar 2006 @ 12:09 PSTrlaskarDatabaseTopicSyntax to Create a surrogate keyNeed to create a table with surrogate keys.
58322 Mar 2006 @ 01:40 PSTTD_ArchDatabaseReplyIdentity Column Not Coming in a sequence. Need Suggestion.This also works:insert partitbl (k)SELECT sum(1) over (rows unbounded preceding) As ROW_ID from dbc.databases;
58222 Mar 2006 @ 01:15 PSTTD_ArchJobsReplyTeradata Professional needed (South Africa)Appreciate if you can mention your work-id (outlook id) rather than yahoo or rediff or hotmail ids.Just to be ensure that the postings are authentic.Thanks.
58122 Mar 2006 @ 01:15 PSTTD_ArchJobsReplylooking for job: advanced teradata certified professionalAppreciate if you can mention your work-id (outlook id) rather than yahoo or rediff or hotmail ids.Just to be ensure that the postings are authentic.Thanks.
58021 Mar 2006 @ 11:58 PSTANGELAnalyticsReplyTeradata function equivalent to 'LIKE %..%' in TeradataHi,We can use ESCAPE to locate a wildcard character.For example SELECT TABLENAME FROM DBC.TABLESwhere tablename like ('-------\_%)' ESCAPE '\'This will return all tables where '_' is in eighth posi...
57921 Mar 2006 @ 05:51 PSTKksJobsTopicTeradata Professional needed (South Africa)Hello all,Teradata Professional needed for a leading financial company in South Africa ,you should have more than 1 yr experience on Teradata as Teradata Developer/ ETL / DBA etc. in a large projec...
57821 Mar 2006 @ 04:45 PSTJenn Daly- Pomeroy ITJobsTopicTeradata DBA needed in NYCMy name is Jennifer Daly. I am a Technical Recruiter with Pomeroy IT Solutions. Currently, I have a Teradata DBA opening available in NYC. This client, a large insurance services corporation, is lo...
57721 Mar 2006 @ 04:15 PSTshaik.feroz@aaa-calif.comDatabaseReplyRun an Update with a subselectThe query will fail with "illegal usage of alias name "because we cannot alias a table with the update clausethe aliasing should be done at the from clause.so update table1 awill failthis can be wr...
57621 Mar 2006 @ 04:01 PSTShri RaoConnectivityTopicWhich is the latest oledb driver for windows 2003/XP SP2COuld you please let me know the latest OLE DB driver for windows 2003, XP Sp2TIA,Shri
57521 Mar 2006 @ 03:32 PSTDragonIVDatabaseReplyRun an Update with a subselectok, and in a similar vein:update table1 afrom( select col1 ,col2 ,col3 from table2 b where b.keycol = a.keycol)doesn't seem to work, as I get an illegal us...
57421 Mar 2006 @ 02:37 PSTwilliamdieterDatabaseReplyon product joinSeveral key things you can look at:1. Ensure statistics are collected on join columns - This is especially imporatant if the column you are joining on are not unique. If your join column only has a...
57321 Mar 2006 @ 01:45 PSTwilliamdieterDatabaseReplySpool Space ErrorIf you are trying to get the month and year for a date, you might want to try using something elseselect*frommytablewhereextract(year from columnname) = 2006andextract(month from columnname) = 3;or...
57221 Mar 2006 @ 01:37 PSTwilliamdieterDatabaseReplyTable sizing in bytesSomething that might give you a bit more information.-- Tables and their size Selecttbl.DatabaseName,tbl.TableName,tbl.CreatorName as Creator,sum(tsize.currentperm) asPermSize,max(tsize.currentperm...
57121 Mar 2006 @ 01:28 PSTwilliamdieterDatabaseReplyIdentity Column Not Coming in a sequence. Need Suggestion.Try this:insert into rahulj.partitbl (unique_column,mycolumn)select row_number() over (order by mycolumn),mycolumn from rahulj.partitbl;
57021 Mar 2006 @ 01:25 PSTwilliamdieterDatabaseReplyRun an Update with a subselecta bit cleaner :update afromtable1 a,(selectcolumn1,min(column2) as column2fromtable2group by 1) bsetcolumn2 = b.column2wherea.column1 = b.column1;If table2 has more rows than table1 you might want ...
56921 Mar 2006 @ 01:11 PSTMNagatToolsReplyMonitoring rollback / abort progressThanks Fred.Although I'd like to have more detailed info on what happenned to the query, the recovery console does it for us now since we have an estimate of how long it will take to finish.
56821 Mar 2006 @ 10:44 PSTwilliamdieterConnectivityTopicConnection Pooling with Visual Basic .NETHey everyone, I have run into some issues while connecting to Teradata through .NETIt's my understanding that .NET doesn't maintain a single connection to Teradata, it might open several connection...

Pages