#DateForumTypeThreadPost
2202 Jul 2008 @ 03:44 PDTToolsTopicconnection problem in Express EditionHii am trying to run a fastexport script through a demo express edition. the script is .logtable temp;.logon demotdat/tduser;database tpch;.begin export sessions 12;.export outfile c:\order.txt mls...
2111 Jun 2008 @ 09:46 PDTToolsReplyfastload between table to tableHi thanks for your reply.how about multiload and tpump? that also loads from flat file to a table and not from table to table?
2010 Jun 2008 @ 05:40 PDTToolsReplyconfiguration of PSA in demo CDThanks,it worked.http://www.teradata.com/teradataforum/Skins%5CClassic%5CImages/MessageIcons/Smile.gif[Smile]
1910 Jun 2008 @ 05:33 PDTToolsTopicfastload between table to tableHi alli'm looking for a clarification on fastload utility. my doubt is that, is it possible to load an empty table from some other populated table?. if yes could you please give me a sample script....
1810 Apr 2008 @ 11:35 PDTToolsTopicconfiguration of PSA in demo CDHi i am trying to connect to the priority scheduler administrator through Demo CD. Its asking System(DBS) Name, userid, password. i gave system name as localhost / mycomputer name and username, pas...
1724 Nov 2006 @ 02:29 PSTUDATopicparticular rowHow to select only a particular row from a table which i am interested based on position. not a set of rows but only that row which i am interested. in oracle we can do like thisSELECT * FROM EMP W...
1625 Sep 2006 @ 11:52 PDTDatabaseReplyWhy No confidenceHi LeoThanks for the i/p. may i know from where can i get the information regarding Derived stats. I checked it in all the teradata pdf, but i am unable to find the term called derived stats. can u...
1512 Sep 2006 @ 10:55 PDTDatabaseTopicWhy No confidenceHi a step in An Explain plan showing no confidence, 9) We do an all-AMPs JOIN step from Spool 11 (Last Use) by way of an all-rows scan, which is joined to Spool 12 (Last Use) by way of an all...
1414 Jul 2006 @ 02:13 PDTDatabaseReplyoperation on current_TimstampThanks vinod, it helped me a lot.
1313 Jul 2006 @ 02:02 PDTDatabaseTopicoperation on current_TimstampHow to substract an hardcoded value from current_Timestamp. i am giving the following queries but it is throwing an error saying "5407 Invalid operation on ANSI Datetime or interval value"i tried w...
1206 Jul 2006 @ 06:53 PDTAnalyticsTopiccount of distinctHow to get the count(combination of distinct values of two columns together). i am giving the query in the following wayselect count(distinct INVENTORY_ITEM_KEY,COST_TYPE_KEY) from ITEM_COST_DETAIL...
1129 May 2006 @ 09:11 PDTDatabaseReplyDownload Dimensional Modeling (star schema) BookLike that is there any pdf's available on TERADATA Dimensional modelling.
1028 Apr 2006 @ 11:21 PDTUDAReplyconfidence showned in explain planHi TDUseri researched that an index join confidence occurs(in an EXPLAIN PLAN) when the join happenning between primary index column of one table with the primary or secondary index column of the o...
923 Mar 2006 @ 08:45 PSTDatabaseTopicsteps 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.
817 Mar 2006 @ 05:25 PSTDatabaseReplyscript of teradata tablesHi like demobld.sql file of ORACLE is there any script available in Teradata. demobld.sql file contains all the tables like EMP,DEPT,JOBS,SALGRADE Tables structure and the rows for these tables. so...
716 Mar 2006 @ 05:29 PSTDatabaseTopicscript of teradata tablesHi may i know on which pdf i can find the table descriptions, there data about the tables used in the pdf. i.e CUSTOMER,OFFERINGS,ENROLLMENT, COURSES...etc. so that i can work on the examples provi...
613 Mar 2006 @ 11:50 PSTUDAReplyconfidence showned in explain planHi TDuserthanks for the reply especially last tip helped me lot, can u tell me something on Index Join Confidence, how the optimizer shows this kind of confidence.i checked the explain plan step wh...
510 Mar 2006 @ 05:05 PSTDatabaseReplyTimestamp format on teradata retrievalHi Dietercan u explain me how it is showing 2006-03-07 12:49:29 for the next part. i am amazed the format u have mentioned i.e ts (timestamp(0), format 'MM/DD/YYYYBHH:MI:SS')in the second part and ...
409 Mar 2006 @ 04:36 PSTDatabaseTopicon product joinhow to eliminate product join in a query?
321 Feb 2006 @ 10:54 PSTDatabaseTopicconfience showned in explainif the explain plan shows Index Join Confidence for a particular join condition is it better than High Confidence. and also interested to know that how exactly optimizer uses Index Join Confidence,...
220 Feb 2006 @ 10:53 PSTDatabaseTopicdescribe equivalentlike describe command, is there any command available in Teradata to know the columns stored in a viewfor e.g describe(in short desc) user_constraints;the above one will show all the columns availa...
116 Feb 2006 @ 05:11 PSTUDATopicconfidence showned in explain planHi i want to know that, what exactly the difference b/w NO, Low, High and Index Join Confidence showned in the explain plan. And how exactly we convert No Confidence to High confidence.Any Suggesti...