#DateForumTypeThreadPost
1521 Feb 2007 @ 02:23 PSTDatabaseReplyNeed to delete duplicate records from tableUse fastexport 1st to select the rows and then create a flat file of records from the table. And then use fastload to load the records back into the table. Fastload does not load the duplicate reco...
1420 Feb 2007 @ 07:42 PSTUDATopicselect from view UNION ALL spools outIn a query we have a select from a view. The view has been defined using UNION ALL from 2 tables one is the current table having data related to current month and another its archive which has all ...
1307 Feb 2007 @ 01:53 PSTDatabaseReplywants to delete rows older than 2 rows in a colomnFirst try to build an SQL select query with a 'where clause' of the date u mentioned. Check if the data u intend to delete is selected or not. Then change the select to delete with same where claus...
1207 Feb 2007 @ 01:40 PSTAnalyticsReplydelete rows older than 2 years from current dateFirst try to build an SQL select query with a 'where clause' of the date u mentioned. Check if the data u intend to delete is selected or not. Then change the select to delete with same where claus...
1103 Jan 2007 @ 12:18 PSTTrainingReplyTeradata BASICS examination..!!There is no proposal of V2R6 exams as of now. I guess Teradata will notify with lots of information at their site if this is coming. :-)
1003 Jan 2007 @ 12:15 PSTTrainingReplyPlease replyI suggest you read the "Introduction to Teradata RDBMS" Manual forst which is free download from www.ncr.com and then look at the syllabus for the Teradata basics exam in the Teradata certification...
922 Dec 2006 @ 05:51 PSTDatabaseReplyTransfer a table to a different databasearcmain outlog=arcall.out < arcall.in
822 Dec 2006 @ 05:50 PSTDatabaseReplyTransfer a table to a different databasearcmain outlog=arcall.out
722 Dec 2006 @ 05:49 PSTDatabaseReplyTransfer a table to a different databaseIf u have access to unix command prompt then....invoke arcmain.--Command-line invocation of Teradata ARC from Solaris, MPRAS,HP-UX, and AIX:arcmain outlog=arcall.out
622 Dec 2006 @ 05:18 PSTToolsReplygetting table and column names from a query in teradataDictionary tables and views are wonderful source of information to understand what is there in the database. In this case dbc.tables and dbc.columns will serve your requirement whether you pass tab...
522 Dec 2006 @ 04:57 PSTToolsReplyRemoving '.' (dot) from input string--create the tableCREATE SET TABLE test ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT ( col2 CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC)UNIQUE ...
419 Dec 2006 @ 08:47 PSTDatabaseReplyaltering column attributesfrom the error messages manual--------------------------------------------------------------3558 Cannot alter the specified attribute(s) for%VSTR.Explanation: Most column attributes cannot be modif...
319 Dec 2006 @ 12:26 PSTTrainingReplyhow to delete duplicate recordsExport the records to a flatfile and then load using fastload. Fastload does not load the duplicate records.
219 Dec 2006 @ 12:17 PSTTrainingReplyImplementation & SQL examsI don't think examination specific books are available online. For examination specific material u need to contact NCR-Education which offers training..I think in India it operates from NCR-Mumbai....
119 Dec 2006 @ 12:08 PSTTrainingReplyApplication developer and Designer examsI would suggest, you go to the www.teradata.com site, search for the syllabus topics and then search for these topics in the documentation available. The preparation will be comprehensive because T...

Pages