#DateForumTypeThreadPost
8218 Mar 2014 @ 05:53 PDTDatabaseReplyCDCCDC is a broad term that applies to any of several methods of detecting only the data that changed for loading to avoid row collisions, maintain history and make ELT/ETL more efficient Cheers
8118 Mar 2014 @ 05:52 PDTDatabaseReplyCalculating day number of the year for a dateYouri, Keep it simple, use the sys_calendar.calendar view.  It will keep you covered for the the next 87 years, and the first day of the year is already  numbered one so you don't ev...
8015 Mar 2014 @ 01:32 PDTDatabaseReplyPerformance Tuning - Report for analysisTssr, Generally those are available as part of a performance tuning engagement provided by the Performance COE @ Teradata.   Cheers
7914 Mar 2014 @ 04:31 PDTAnalyticsReplyWhy FastLoad Does not support NUSI ?Ratnam, Set your target column to a character data type long enough to support either format, in your example char(10) or varchar(10) .   Then transform the data into a date data type be...
7808 Mar 2014 @ 07:29 PSTDatabaseReplyHow is the Node DecidedHi Mithun, It's all about the Primary Index.  Teradata uses a fixed hash map to determine where to put each row, based upon the hash result of the primary index column(s).  The pars...
7707 Mar 2014 @ 04:23 PSTDatabaseReplyUsing Teradata in OLTP applicationHi Sri, What does the dbql log look like for the oscillating query? and How are you measuring your response times? With an explain plan that clean, i'm wondering if it might not be a net...
7607 Mar 2014 @ 04:17 PSTConnectivityReplyCan I use the Teradata ODBC Linux drivers with Mac OS XTeradata studio should work great on a Mac. 
7524 Feb 2014 @ 05:19 PSTDatabaseReplyFiltering records that have overlapping datesI would strongly suggest you investigate the Period datatype and it's associated functions.  Depending upon which version of TD you're running, you may not have to alter the table DDL,...
7421 Feb 2014 @ 04:30 PSTDatabaseReplyDate as IntegerJust a question here, Why do you presume that the integer will be 'easy to join'? As Dieter and Adeel have pointed out, your second update statement is in error.  You're telling t...
7319 Feb 2014 @ 03:55 PSTViewpointReplyAnalyze Query logsMeena, Do you have DBQL logging enabled? These all look like pretty simple queries from the dbql tables.  it's a pretty direct task to develop some views that would represent these m...
7219 Feb 2014 @ 03:53 PSTDatabaseReplyOrder by DateOne of the tenets in basic relational theory is that order of the columns and rows in a table is irrelevant.  If your results come out in the order you'd like them to it's probably dum...
7117 Feb 2014 @ 06:02 PSTDatabaseReplyALTER_PPIonce you recreate the table, you need to insert/select and collect the appropriate statistics  
7017 Feb 2014 @ 04:58 PSTDatabaseReplyALTER_PPIthe syntax to alter the PPI is as follows: create multiset table dbname.tablename, no fallback, no before journal, no after journal, checksum = default (column1 datatype ,column2 datatype ... ...
6916 Feb 2014 @ 08:57 PSTGeneralReplyIs dropping/creating tables over and over an ok or should you leave the table structure in place?This is a great use case for a Global Temporary Table.  You avoid the reptitive hits on the dbc tables, as once the GTT is created the ddl sticks around even after the session ends, unlike a v...
6822 Jan 2014 @ 10:10 PSTDatabaseReplyGetting week of the year from a date Select mv.col1, mv.col2, c.week_of_year from MyView mv inner join sys_calendar.calendar c on mv.my_dat= c.calendar_date Join to the sys_calendar.calendar view on your_date = calendar_date and ...
6702 Jan 2014 @ 05:53 PSTDatabaseReplyJoin two tables using like statementmost of these solutions will "work", but they all have one fatal flaw, they force a full table scan of T1, the column that you are using a function to evaluate.  depending upon the s...
6602 Jan 2014 @ 02:09 PSTToolsReplyWhen are secondary indexes required?Santanu, In your last chunk of DDL, you partitioned by LastModDate.  You aren't partitioned by RecordId.  The PI is hashed to distribute the data across the amps, so asking for a que...
6502 Jan 2014 @ 01:56 PSTDatabaseReplyPerm Space and Spool space Greetings, I sincerely hope that you are not managing spool space on a user by user basis.  This makes the DBA's job much more complex than it needs to be.  You should be developing ...
6402 Jan 2014 @ 01:47 PSTGeneralReplySAY NO or NEVER to Agile Methodology in DWH projectRaja, I would reply that it all depends upon the strength of the leadership and project manager.  I've seen both Agile and Waterfall projects succeed and fail.  It generally comes do...
6301 Jan 2014 @ 07:40 PSTToolsReplyWhen are secondary indexes required?Saeed, You've partitioned the table on Transaction_Dt, but the query is asking for Trans_id.  Regardless of the demographics, it will never give you DPE with that configuration. As a tes...
6231 Dec 2013 @ 05:27 PSTCloud ComputingReplyVMWARE and TD 14.10That should get you started.  The TD download contains everything you need to run the VM
6131 Dec 2013 @ 05:25 PSTDatabaseReplyUnable to Create a Columnar Table after upgrading to 14Greetings, You need to have your Teradata CS team turn on columnar.
6026 Dec 2013 @ 11:22 PSTToolsReplyWhen are secondary indexes required?greetings, Secondary indexes are typically defined to improve performance with regard to residual conditions in the where clause.  There are multiple ways to improve performance of these cond...
5925 Dec 2013 @ 07:03 PSTDatabaseReplyMany tables or many databases?If you go the route of one database, based upon your description, you'll be forcing the dba team to maintain object level permissions, never a good idea.  If you create a db for each team,...
5807 Dec 2013 @ 05:44 PSTDatabaseReplyTD14.10 feature experience We just finished a multiphased upgrade to 14.10/SLES11 on 6680's that were previously running 13.10/SLES 10. We've had no issues with anything running at all.  Our pre-upgrade testing ...

Pages