#DateForumTypeThreadPost
18207 Sep 2016 @ 10:24 PDTToolsReplyArcmainT@YS = Teradata At Your Service  Somebody in your organization, probably the lead DBA should have an account set up to download all the wonders of TD documentation, hotfixes and new releases...
18119 Aug 2016 @ 07:09 PDTDatabaseReplyCreate NUPI and USI having the same ColumnWell for starters, you should be building a multiset table, especially if you're going to use a unique index.  Using a NUPI with a USI is a pretty standard construct, as the NUPI is really...
18019 Aug 2016 @ 07:02 PDTDatabaseReplyResource Monitoring While Running Sql querriesTeradata Viewpoint is your monitoring portal and a window to all things operational.
17908 Aug 2016 @ 09:10 PDTTrainingReplyNeed help to find out Teradata certification materialRead the manuals, get some experience and learn for yourself via hands on experience.  Just passing the test has zero value in the real world. If you can only regurgitate the manuals without ...
17804 Aug 2016 @ 06:58 PDTData ModelingReplyAJI creation for a single high priority queryFor starters, you can't build a JI against view columns, you'll need to start with the base table columns.  start by recreating this exact query with base table columns, including any ...
17725 Jul 2016 @ 05:07 PDTDatabaseReplyDBQL MetricsI'm not Dieter... and i don't play him on TV, but to answer your question, The ...Norm columns are intended to be used in co-existence systems, multiple generations of hardware in one syste...
17622 Jul 2016 @ 06:09 PDTDatabaseReplyConsequential inserts into large fact table performing very slow inside stored ProcedureCheck the performance of your complex source views, that SQL is going to be run.  I'm not sure how you'd use volatile tables here.  Can you post the DDL for the target table, SP a...
17520 Jul 2016 @ 08:06 PDTToolsReplyFOR EACH clause in Teratada SQLare you looking for the first day of each month for the year ?   if so , join to the sys_calendar.calendar view on the date, with the additional condition of where day_of_month = 1
17415 Jul 2016 @ 07:17 PDTDatabaseReplyHow to CREATE TABLE(copy) without any index and parititions present on source tableyou'll need to add the on commit preserve rows if you want your data to stick around, and depending upon the number of rows in the volatile table, you may have introduced some significant spool...
17328 Jun 2016 @ 06:04 PDTDatabaseReplyit seems teradata doesn't support != as not equal, right?A left outer join will work as well.
17220 May 2016 @ 06:00 PDTToolsReplyNeed help in using SQL AssistantRather than expecting the tool to keep you from "human mistakes", you should probably review and update the permissions granted to users on the production box, i.e. revoke the delete perm...
17108 Mar 2016 @ 12:20 PSTDatabaseReplyLoading SQL Server TimeStamp Varchar to Teradata Table via TPTYou've got your answer, load it to varchar(30)... the tpt error says it all.  delimited requires ...   
17024 Feb 2016 @ 09:49 PSTTrainingReplyTeradata 14 basics certification informationYou can download ALL of the relevant documentation at teradata.com.  
16913 Feb 2016 @ 02:01 PSTPrivate Forum
16802 Feb 2016 @ 10:26 PSTDatabaseReplyQuery running for more than 16 hrs for insertion operationSachins, From what you've posted DDL wise, this doesn't look like it's optimized for Teradata.  You've got Unique Primary Indexes on all the tables, in TD, the PI is NOT the s...
16702 Feb 2016 @ 07:10 PSTDatabaseReplyQuery running for more than 16 hrs for insertion operationSachins, Can you post the table DDL for call hist, call class and route hist? There are several strategies that may significantly reduce your processing time.  Eliminating the substrings in ...
16620 Jan 2016 @ 04:38 PSTGeneralReplyHow to see the unused indexes for a queryMahesh, You need to flip your perspective and look at the indexes that are used, either in the explain plan or by having your DBA turn on object use tracking.  Allison's query gives you t...
16521 Dec 2015 @ 04:56 PSTDatabaseReplyDynamic partition not workingadd a no range and unknown partition to partitioning phrase and retry your insert.    
16423 Oct 2015 @ 07:26 PDTDatabaseReplyRows to columns query it would help if your data made sense.  For example, in your desired results, you have RAM A 1 1,2 where does the 2 in the last column come from?  there isn't another RAM A row in you...
16316 Oct 2015 @ 05:24 PDTDatabaseReplyDDL's Compare of 2 tablesYou'll need a third party tool, Atanasuite or UltraEdit/UltraCompare, as previously mentioned
16215 Oct 2015 @ 04:58 PDTDatabaseReplyRe write a query"and b.ER_ID not = a.ER_ID" is what's killing your performance.. rewrite it as a loj on a.tran_id = b.tran_id where a.ac_dt > b.ac_dt and b.er_id is null (assuming "a" is...
16115 Oct 2015 @ 04:52 PDTDatabaseReplyREcursive processA common error that results in recursive queries/views spooling out is the missing "depth" limiter.   without the depth column and the where depth <= 100 it doesn't know where...
16007 Sep 2015 @ 03:31 PDTGeneralReplyRow header, table header and block headerit's all in the online documentation
15907 Sep 2015 @ 03:30 PDTDatabaseReplyEstimate / Project a table sizeprofile the source(s)...
15807 Sep 2015 @ 03:30 PDTDatabaseReplyNeed a query union two outer joins

Pages