#DateForumTypeThreadPost
10719 Aug 2014 @ 01:12 PDTDatabaseReplyPartition effectivenessRobin, Did you collect stats on the partition?
10615 Aug 2014 @ 06:28 PDTDatabaseReplyDetermine new table skew for a different PIand this works too...:) select sum(tallyset.rowtally) ,min(tallyset.rowtally) ,max(tallyset.rowtally) ,avg(tallyset.rowtally) ,100 - (avg(tallyset.rowtally)/max(tallyset.rowtally) *100) as sk...
10514 Aug 2014 @ 02:08 PDTToolsReplyTeradata to Oracle data transferFast export from TD and Bulkload into ORA...or a data warehouse automation tool like Wherescape Red 
10410 Aug 2014 @ 01:52 PDTGeneralReplyCase statementHi Pragov,  Have you considered loading this data into a table using the semi-colon as a column delimiter, which makes your query much simpler.  Your spool will definitely drop and your ...
10307 Aug 2014 @ 05:56 PDTData ModelingReplyCalendar dimensionWhat version of TD are you on?
10205 Aug 2014 @ 07:41 PDTDatabaseReplyWrapping SELECT tests in a PROCEDURE with activity count you can set up a proc that uses dymanic sql, store your select statements in a queue table, call them with a select and consume and use the system variable activity_count for each statement to chec...
10104 Aug 2014 @ 07:01 PDTDatabaseReplyHow to capture first 4 days from all the month using teradataQuery the sys_calendar.calendar view.... where day_of_month < 5....and other residual conditions as necessary.
10023 Jul 2014 @ 10:14 PDTDatabaseReplySecondary index subtable You can see "hints" about its' structure, as noted by the two previous posts, but you can't see or access the table directly.
9911 Jul 2014 @ 07:33 PDTDatabaseReplyAll AMP active for Updates based on primary indexThere may be rows on every amp that are getting updated. 
9808 Jul 2014 @ 04:55 PDTDatabaseReplyalternate for cast('9999-12-31 00:00:00.0' as timestamp) Greetings Altaaf, You'll get much more productive responses if you post the query with an explain plan.  I'm not sure that cast is expensive enough to cause you any performance issues...
9729 Jun 2014 @ 07:23 PDTDatabaseReplyDB Creation And AccountThe account string is one of the basic elements of performance management and tuning in Teradata.  It doesn't have anything to do with a user "account" aka logon.   The ...
9628 Jun 2014 @ 07:54 PDTDatabaseReplyQuery to Delete all the records in a table in Teradatathe delete syntax permeating this thread is spot on, but if you've got a large table and need to truncate the entire table, add the "all" keyword to the end... delete from dbname.tab...
9517 Jun 2014 @ 09:14 PDTData ModelingReplyDatabase Design ToolIt's shameless plug time!  Take a look at Wherescape Red and 3D.  Red is the only integrated development environment for datawarehousing that I've ever seen.  It will solve y...
9413 Jun 2014 @ 07:14 PDTTeradata StudioReplyHow to lad the keycolumn level sapaces data Mahesh, You don't load through an amp directly.  The data is hashed by the system and distributed across amps via the PI.  Single amp operations are typically queries where the only ...
9317 May 2014 @ 05:29 PDTDatabaseReplyhow to create a user, database and table in sql assistant?Purna, You can run the ddl to create what you need in bteq.  Make sure the logon id you're using has Create database and create table privileges.
9217 May 2014 @ 05:22 PDTDatabaseReplyTPT instead of FastLoadThe TPT operators are analogues of the standalone utilities.  Each has it's place in the ELT world and works differently.  It can't really be said that TPT Stream is better than F...
9116 May 2014 @ 06:54 PDTDatabaseReplyOutput of script will be a set of select queriesArindam, We typically don't answer Oracle specific requests in the Teradata forum.     In Teradata, however, there are multiple ways to do this via some dynamic sql and the dbc tab...
9014 May 2014 @ 05:45 PDTDatabaseReplyTeradata 13 Vs 14The release summaries that ulrich pointed you to describe all the new features and fuctionality, i.e. the difference between TD 13 and TD 14, including the dot releases.
8910 May 2014 @ 05:32 PDTToolsReplydownload link for TTU 14.0 is requiredThey're backwards compatible.  you should be fine.
8803 May 2014 @ 05:59 PDTData ModelingReplyUsing a PPI column in PIif your downstream queries don't access the new composite PI you'll have full table scans.  what defines the most common access path to the table with colA and colB?  You've g...
8703 May 2014 @ 05:55 PDTGeneralReplyVolatile Tableseverything you seek can be found....in the user documentation available for free download from Teradata.
8621 Apr 2014 @ 04:49 PDTThird Party SoftwareReplyBi tool cannot read from different databases in teradata?Don't commingle views and tables in the base table db.  If you do that you'll create an administrative mess for the dba's. Create a separate BI db that contains nothing ...
8527 Mar 2014 @ 05:01 PDTThird Party SoftwareReplyExcel to Teradata Session loginsMark, You could make this work with Teradata Wallet.  Install TD Wallet on your pc and embed the TD wallet string in your odbc connection.  Your password stays protected, all that's ...
8422 Mar 2014 @ 11:20 PDTDatabaseReplyTD questionsreally?
8320 Mar 2014 @ 03:53 PDTCloud ComputingReplyHow do I access a VMWare hosted Teradata Express from a local TD Mapping ManagerAmit, All you should need is VMWare, no install of linux is required.  Download and install a VMWare client, either server or player.  Unzip the TDExpress package and open up the virtual...

Pages