#DateForumTypeThreadPost
3414 Dec 2014 @ 07:29 PSTToolsTopicconfidence levels wrt date of statsWill optimizer check the date on which the stats are collected before suggesting the confidence levels? 
3313 Nov 2013 @ 05:16 PSTTeradata ApplicationsReplyRe:Volatile Tables In Stored_Procedure...Is  it volatile table  not allowed order by clause? > No. Add a column wrt  sequence No as required , and used it in  "order by "
3217 Dec 2010 @ 09:51 PSTGeneralTopicNo more spool error- sel * from table sqlhello all My table size is around 150 GB When I tried to execute a simple sql " select * from the table " No more spool error occurred any specific reason !!
3120 Jul 2010 @ 08:46 PDTToolsTopicFLOAD V/S MLAODEveryone says there are 5 phases in MLOAD and 2 phases in FLOAD I am little bit puzzled As FLOAD will also do the below steps 1. logon ,session ,logtable, UV table ET table creations as Prelim...
3020 Jul 2010 @ 08:34 PDTDatabaseTopicVolatile table V/S Perminent tableI have created a volatile table with table name TEMP1 And a permanent table DATABASENAME.TEMP1 When I do a show or help or select on table TEMP1 I am able to fetch volatile table TEMP1 result...
2925 Jul 2009 @ 05:23 PDTAnalyticsReplyLock Info in teradataThe Lock Display utility provides a snapshot capture of all real-time database locks.Also we can take the help of PMON
2824 Jul 2009 @ 09:08 PDTAnalyticsReplysmall SQl querywe can also try with Recursive SQLrefer to the below linkhttp://www.teradata.com/tdmo/v06n03/Tech2Tech/InsidersWarehouse/OddballSQLTricks.aspxhttp://www.teradata.com/tdmo/v06n03/Tech2Tech/InsidersW...
2709 Apr 2009 @ 11:33 PDTAnalyticsTopicdrop Statistics before recollectingDo we need to drop Statistics before Re-Collecting Statistics on the same column for a table ?if yes pls let me know why!!!!
2609 Apr 2009 @ 06:10 PDTDatabaseTopicDrop statisticshi,Is it required to drop statistics before recollecting the statistics on a (index)column.Thanks,Rahul.
2511 Feb 2009 @ 04:16 PSTUDAReplySummarize data based on weeksTry this as week days we can directly extract Select Item_ID,sum(Total_dollars),sum(Total_Units)From ttemp.ach96_salesGroup By week(Point_of_sale_Dt) , Item_IDOrder By week(Point_of_sale_Dt)
2411 Feb 2009 @ 01:51 PSTUDAReplywhy should we use SET table ?Hi Jim Chapman / Fred PluebellI am concerned about Time taken to load the Set Vs MultiSet tablesIn my application there are many Set tables created for storing temp result For loading these set tab...
2309 Feb 2009 @ 03:24 PSTToolsTopicHow to auto generate tpump/fast load scriptHi AllI know we can get MLoad Script auto generated using Fexp Are there any similar short cuts to generate Tpump or Fast load script instead of coding entire thing?
2209 Feb 2009 @ 03:02 PSTTrainingReplyproblem with importHi Prakhartry to usecast('07/07/08' as date format 'dd/mm/yy') cast( :x as date format 'dd/mm/yy')
2109 Feb 2009 @ 01:15 PSTUDAReplywhat is the sqlloader equivalent in Teradataone more option is TpumpTPump=====* Loads data to TeraData from aMainframe or Lan flat file* Processes INSERTS, UPDATES or DELETES* Tables are usually populated.* Can have Secondary Indexes and RI ...
2009 Feb 2009 @ 01:09 PSTUDATopicwhy should we use SET table ?A SET table force Teradata to check for duplicate rows every time a row is inserted or updated. This can cause a lot of overhead on such operations. Why cant we use multiset tables for all Tables w...
1909 Feb 2009 @ 12:01 PSTUDAReplycast (-18989899 as date)Thank you FredI tried in Bteq and as well as in Teradata its working :)GR8
1809 Feb 2009 @ 11:06 PSTUDAReplyStar schema referential integrity errorReasons to implement RI– Data integrity and consistency– Increases development productivity – usersdon’t have to code SQL statements to enforcereferential constraints– Optimized performan...
1709 Feb 2009 @ 10:21 PSTUDAReplyMLOAD Worktable errorKeerthan I think you got the solution if not pls see the below Remedy: Drop the existing worktable and error tablesof the MLoad job. If the error is diagnosed before theend of the acquisition phase...
1609 Feb 2009 @ 10:01 PSTUDAReplyWild CharacterHi Keerthan,Once I faces similar challenge, We can insert such special char using Bteq1st load the data into a .txt file and try to insert using Bteq script this will help
1509 Feb 2009 @ 08:44 PSTUDAReplycast (-18989899 as date)Hi Fred and PetrThank a lot for the clarifying my doubt But there is something fishy, from ‘0001-01-01’ to ‘0099-12-31’ its blank Do you know why this 1st 99yrs is treated as blank in Terad...
1404 Feb 2009 @ 03:12 PSTUDATopiccast (-18989899 as date)Hi ,Table DDL is showing as Date_column DATE FORMAT 'YYYY-MM-DD' NOT NULL DEFAULT DATE ,But I am able to insert -18989899 in to the Date_column And when I do select I am fetching a bl...
1308 Jan 2008 @ 12:38 PSTToolsTopicINMOD -> COPYING FROM 1 DB TO OTHER DB OF DIFFERENT SYSTEMHELLO ALL,i am loading the data of 1 table of production to test ENV , the 2 ENV reside on 2 different serversright now i am fexp to my local sys to a file n then mloading to test envalso tried wit...
1226 Nov 2007 @ 12:46 PSTAnalyticsReplyWITH RECURSIVETHANK YOU VERY MUCH , AND 1 MORE DOUBT WHY YOU ARE TRYING TO GIVE "IN" INSTAD OF "NOT IN"
1124 Nov 2007 @ 07:43 PSTAnalyticsTopicWITH RECURSIVEcreate tabel --- CREATE SET TABLE RAHUL_DB.cbn_cls ,FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT ( cbn_cls_id INTEGER, cbn_cls VARCHAR(13) CHAR...
1015 Nov 2007 @ 12:02 PSTAnalyticsTopicANSI vs. Teradata SQLhello all,can any 1 help me with the differences between ANSI vs. Teradata SQLamy meterial which can help me out

Pages