#DateForumTypeThreadPost
14020 Mar 2009 @ 02:21 PDTToolsReplyHow to find No. of Records present in Each AMP or a Node for a given Table through SQL?Please check the 'sample scripts' sub-section in the chapter of Teradata manual on "Performance management"There are lot of scripts there.One example reproduced here.../* The following query will ...
13920 Mar 2009 @ 01:35 PDTToolsReplyWhy MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?Multiload builds a separate NUSI change row to be applied to each NUSI subtable after all of the rows have been applied to the primary table. Hence...but this is not advisable because it degrades p...
13819 Mar 2009 @ 12:26 PDTAnalyticsReplyUsing Terdata ODBC trying to connect teradata Database through SQL 2000Wow. That indeed is a good experiment. What exactly did you do can you share step by step?
13710 Mar 2009 @ 10:46 PDTUDAReplysomething about Teradata Warehouse 7.1Was that an incomplete question or JFYI only?
13610 Mar 2009 @ 10:45 PDTUDAReplySQL query to Teradata SQLWhere are the queries?
13510 Mar 2009 @ 10:37 PDTUDAReplyEDW Metrics DashboardI did the following in google and found some presentations.{EDW Metrics sample Dashboards filetype:ppt}
13410 Mar 2009 @ 10:17 PDTUDAReplyData Warehousing/BI SoftwareA very broad question I feel. By far I think spreadsheet tools are the most widely used software tools used in Business Intelligence / datawarehousing. No offence meant. :-)
13310 Mar 2009 @ 10:12 PDTUDAReplyHow does teradata's db modeling style differ from the rest?In a nut shell it is 3NF oriented. Depending on other commercial requirements it shoots upto ODS, Star, Snow etc.
13210 Mar 2009 @ 10:08 PDTUDAReplyrows affected by SQL - Query LogIt might not be the same for every installation in my view. For example in a situation where tracking is enabled like Tracking System Events, Tracking Logon Rules or audit trails the tables like D...
13110 Mar 2009 @ 09:53 PDTUDAReplyDropping table indices - Data PagesPI cannot be dropped anyway. There are optimized work arounds to drop a SI. Which indices are you discussing here? The filesystem and the automatic defragmentation takes care of the white spaces. S...
13010 Mar 2009 @ 09:48 PDTUDAReplySearching what table indices are used.I think the only way is to capture the output of "explain plans" of all the queries and do a 'grep' on the secondary indexes before you analyze the text if the idex is used.
12910 Mar 2009 @ 09:36 PDTUDAReplytechnologiesAre you looking for tools in the BI space or Teradata in particular?Teradata.com has got list and brief to broad descriptions of all the tools it sells.The site you mentioned refers to tools of ENV...
12810 Mar 2009 @ 09:33 PDTUDAReplyCan we use CASE in CREATE JOIN INDEXCan you share your SQL?
12710 Mar 2009 @ 08:35 PDTUDAReplyLoading from Oracle Warehouse Builder to TeradataI dont think OWB can have Teradata as target database. It can have Teradata as source database.
12610 Mar 2009 @ 08:34 PDTUDAReplyApproach to migrate Oracle tables to Teradata which has CLOB/BLOBAre the equivalent datatypes CLOB and BLOB not sufficient? Should be able to do with that.
12510 Mar 2009 @ 08:24 PDTUDAReplyResearch Articles urgently neededhttp://www.vldb.org/Check this site. You may find some quality research papers.Good luck.
12410 Mar 2009 @ 06:52 PDTDatabaseReplyCan we create 2 Foreign Keys on same column referring to 2 different tablesI did not have any problem while creating the tables. So I guess it might be possible.
12309 Mar 2009 @ 10:00 PDTUDAReplySub query runs by its self, full query wontCan you share what is the error number?
12209 Mar 2009 @ 09:49 PDTUDAReplyTeradata 12: Snowflake Vs Star query performanceIt might not be star or snowflake which is the reason for the bad response. Check if the statistics are update and the collection is on right columns namely the columns participating in the join et...
12109 Mar 2009 @ 09:47 PDTUDAReplyDecoding and Filtering MonthsCan you give the column datatype which is storing the month-id's? Is there a separate column which is storing the corresponding data also? Can u please share?
12009 Mar 2009 @ 09:31 PDTUDAReplyUsing relational operators for CHAREven I got the same result as Carlos.Deepak. Across products the ACSII table will remain the same.http://www.asciitable.com/
11909 Mar 2009 @ 07:29 PDTThird Party SoftwareReplyInformatica vs Teradata BTEQOne potential showstopper for any bteq dependent job is the connection sustainability which will not be there in your case...because both source and target are in the same database. I guess this is...
11809 Mar 2009 @ 07:17 PDTUDAReplyUsing relational operators for CHARWhat exactly are you trying to find out?Which character had greater binary value?? or which is the succeeding number in storage?Can you rephrase?
11718 Feb 2009 @ 09:23 PSTUDAReplyExplain plan vs query run timeCan you post your query to the forum?There are many reasons why there is difference of time estimate and actual time of execution.One fundamental reason:Due to skewed distribution of data and the a...
11618 Feb 2009 @ 09:09 PSTTrainingReplyTraining or Courses Online[font=Tahoma][size=7][/size][/font]Please get in touch with Teradata education. They have web based training modules which are available for price or for internal employees / contractors.Otherwise ...

Pages