All forum activity

#DateUserForumTypeThreadPost
59423 Mar 2006 @ 08:45 PSTdixonDatabaseTopicsteps to work on TERADATAHi Allonce i installed teradata demo into my system. what is the next step. when, where and what i need to start to work Onto it. since bcoz i am new to TERADATA i need this basic information.Thanks.
59323 Mar 2006 @ 07:55 PSTmatty.jiangDatabaseTopicwhy does sql cannot pass systax?CREATE MULTISET TABLE ODS_TIME ( DATE_ID DATE NOT NULL, DAY_OF_WEEK VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC, MONTH VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC, ...
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 ...

Pages