#DateForumTypeThreadPost
3230 Apr 2008 @ 04:46 PDTAnalyticsReplyHow to get pagination in Teradata..??In TD we cant get the rows based on the row number,we have some functions like Top,sample you can try these two but if you want to take out based on the row number.You can strategize your loading o...
3125 Jan 2008 @ 05:45 PSTUDATopicMaster Data ManagementHi ,Can any body throw some light on Master data management ?Is there any general docs available for it..
3025 May 2007 @ 04:05 PDTDatabaseReplyTable lockhi, yep the same document....but not detaily... you can check the doc Teradata utilities doc..rather than.....teradata administrator...
2924 May 2007 @ 11:26 PDTDatabaseReplyTable lockhi Sakthi, check the site Info.ncr.com doc: Database Administrator
2810 May 2007 @ 05:16 PDTUDAReplyLearning suportjust surf through this site... http://www.info.ncr.comdownload the material and learn TD.
2708 May 2007 @ 03:48 PDTDatabaseReplyQuery optimization techniques?just give us some clear picture about what kinda optimization you need...so that it will be easy to suggest.
2614 Dec 2006 @ 12:16 PSTDatabaseReplySQL optimization helpHi Aravind, I came to know from ur previous postings that u r in working in V2R6...now u can create a perm table with the partition of the Date column...join the both tables and load into the per...
2506 Dec 2006 @ 07:42 PSTToolsReply[INFO] Teradata Administrator and password...err.no.3682Hi,Err cd defines that ur passwd expired and u ve to change it by means of the modify User....If u dont have the access right for executing modify user...then ur SYSADMIN user must reset it....then...
2427 Nov 2006 @ 08:00 PSTDatabaseReplyCheckSumThe problem in the diskdrive and disk array...can corrupt the data....these type of corrupted data cant be found easily..but queries against these corrupted data will get u wrong answers..we can fi...
2327 Nov 2006 @ 02:34 PSTDatabaseReplyCheckSumHi, CheckSum is used to check the Disk I/O Integrity Check.....Problems originating in disk drive and disk array can also corrupt the data, this kind of error will be in block and sector level ....
2224 Nov 2006 @ 04:19 PSTUDAReply3004 : User Identification is not authorisedhi, Check whether the user is valid .....if it is valid then check whether the user has execute privilage in the macro DBC.TwoPCRule If the user doesnt have the execute privilage in the macr...
2122 Nov 2006 @ 08:09 PSTDatabaseReplyTERADATA SQL MATERIALwww.info.ncr.com
2022 Nov 2006 @ 01:35 PSTTrainingReplyRegarding Certification ExamsDont Worry...They Will intimate well ahead about the release of exams for v2r7 as far as i know the release will be in the begining of 2008.
1914 Nov 2006 @ 06:49 PSTDatabaseReplyPPI - Global Temporary TableHi Manu, The DDL you have posted works fine on V2R6.. check ur version once again...
1814 Nov 2006 @ 12:19 PSTToolsReplyDuplicate entry tracking which FastLoad does not loadHi, In Fastload the duplicate rows..will be tracked and loaded in the error table..which contain three columns err code ,err fieldname,dataparcel.The Count of the duplicate rows will be displayed...
1713 Nov 2006 @ 02:05 PSTUDAReplyCollect Stats n Refresh StatsWHEN EVER THERE IS EXTENSIVE INSERTs, DELETEs, UPDATEs, OR ANY OTHER MAINTANENCE TO ANY COLUMNS WHICH IS CONTAINING STATISTICS.WE SHOULD REFRESH THE STATS.THE CHANGE OF DATA SHOULD OF 5 TO 10 %
1613 Nov 2006 @ 01:25 PSTDatabaseReplyHow to use/enable Parsing Engine?Hi Uma, There are many method you can optimize ur query...If the collect stats was not there you can collect stats based on ur index columns ...U can change ur PDM according to your business...as...
1513 Nov 2006 @ 12:24 PSTDatabaseReplyGenerating Sequence NumberHi,If u want to generate a sequence number u can try like thi SELECT RANK() OVER (ORDER BY col1,col2,col3,col4 ) FROM TABLEX;
1431 Oct 2006 @ 06:01 PSTDatabaseReplyCurrent Accounta)sel * from DBC.AccountInfo where accountname = account..(this will give all accounts for database,users and profile)if u want more details abt the account.....thensel * from dbc.dbase where accou...
1331 Oct 2006 @ 04:57 PSTDatabaseReplyLooking for View Definition in DBC tablesel CreateTextfrom dbc.tvmwhereTVMName = 'zxcv' -- ur view name by this query u can view the definition..provided u ve access to dbc tables and views.
1230 Oct 2006 @ 06:23 PSTAnalyticsReplyTeradata SQL Assistant: Automatic Renamame an Answerset?Select Set Title (F12) from the Window menu to assign your own title to the Answer Set window.This menu is only available when the focus is in an Answer Set window.But thru Query it is not possible
1123 Oct 2006 @ 02:36 PDTDatabaseTopicIdentity Column as Composite UPI Hi All, I have a identity column in my table and i ve to use it in a composite UPI...I tried but I cant use that , i got err with "Illegal use of identity column" ..so i used it as USI and the...
1013 Oct 2006 @ 12:17 PDTDatabaseReplycontinue question:(on table newly changed)sel * from dbc.tvmwhere LastAlterTimeStamp > (CURRENT_TIMESTAMP - interval '2' day )AND CreateTimeStamp LASTALTERTIMESTAMP;THIS WILL GIVE YOU THE TABLES AND VIEW WHICH ARE ALTERED WITH IN T...
906 Oct 2006 @ 10:21 PDTDatabaseReplywhat is diff stats on coln and Index.Hi,Collecting statistics on a group of columns that are already indexed will only have the statistics of the index .collect stat statements on the particular column against the same group ofcolumn...
827 Sep 2006 @ 08:31 PDTDatabaseReplyrollback in TD.Hi Giri, As far to my knowledge by using the Analayze statement in the Arc and Restore Utility we can find the information like name of each database, data table, journal table, the fallback statu...

Pages