#DateForumTypeThreadPost
11812 Oct 2015 @ 11:17 PDTDatabaseReplydrop/create table stored procedureThanks Dieter,   Let me explain what I am trying to do in a little more detail.  I have set up a STORED_PROCS database that requires a special password to create stored procs.  I h...
11710 Oct 2015 @ 07:35 PDTDatabaseReplySpool Space Error while running a select queryAre you using left outer joins anywhere?  You could be running out of spool when joining spool files as a result of outer joins.  Could also be natural data skew (i.e. sales in NYC vs Far...
11610 Oct 2015 @ 07:29 PDTDatabaseReplyNo spool spaceIs it possible that you are skewing on the week and blowing spool on a few amps?  I don't like using week_code just for that reason.  Maybe keep it at the day grain calculate the week...
11510 Oct 2015 @ 06:52 PDTDatabaseTopicdrop/create table stored procedureHi all, I have been trying to create a stored proc that will dynamically (1) drop a stage table, and then (2) recreate the same stage table.  I would like to write both statements inside a BT...
11419 Jun 2015 @ 02:17 PDTDatabaseReplyTeradata Views created on top of ViewsShouldn't be an issue as long as you don't go to deep in your layers of views.  Hopefully query re-write will fold the views and only access the actual tables that are referenced in th...
11313 Jun 2015 @ 08:33 PDTDatabaseReplyTeradata DBQL logging setup and maintanence document for TD 15I posted the following last August..... crickets!  Does Donna Becker still work for Teradata?   07 Aug 2014 TD15.00 DBQL Migration Scripts I have looked in the...
11228 Jan 2015 @ 10:28 PSTDatabaseReplyDatabase space issuesCan you post the table ddl?
11123 Jan 2015 @ 04:01 PSTToolsReplyNumber of Utility Load SlotsCorrection above... What I pasted into the response was not the notes I collected from Jim Judge and Carrie B. over the years.  This is straight out of a manual.   Joe
11023 Jan 2015 @ 03:59 PSTToolsReplyNumber of Utility Load SlotsHas to do with certain settings in dbcControl and AWT usage.  Here are some notes that I saved over the years from Jim Judge and Carrie B.: Probably more info than you need or want but though...
10923 Jan 2015 @ 03:18 PSTDatabaseReplyCompare two database Tables, row count in each table which are in different servers wow... a response like that almost a year and a half later... gave me a good belly laugh!  :)
10830 Dec 2014 @ 10:59 PSTToolsReplyNamed Pipe jobs failing on checkpoint fileAs always thanks Steve!  We had a contracting firm set up the Data Services configuration and they chose generic named pipes over NPAM for some reason.  I will try to get our ETL team to ...
10729 Dec 2014 @ 02:25 PSTToolsTopicNamed Pipe jobs failing on checkpoint fileWe utilize an ETL tool from a vendor I wish to remain anonymous (starts with an S and ends with a P) :)  This particular vendor has chosen to execute TPTLOAD via tbuild instead of the TPTAPI.&...
10614 Nov 2014 @ 01:40 PSTDatabaseReplyGrant access inside viewIt might be that the view does not have permissions to select from another database.  Is it throwing a permissions error is just not pulling back any rows?   Joe
10527 Oct 2014 @ 03:39 PDTDatabaseReplyHadoop threat to data warehouse vendorsHadoop was not designed to be a production database.  Don't have to worry about anyone using Hadoop as their data warehouse single source of the truth.  To many issues with transactio...
10407 Oct 2014 @ 12:32 PDTDatabaseReplyCreate a SUPER/DBA/POWER UserDoes the user really need/want DBC access rights?  Most I talk to would not want this type of access due to the damage they could accidently do.  I would never give a user DBC rights unde...
10306 Oct 2014 @ 01:19 PDTDatabaseTopicOracle vs Teradata ParallelismHello Everyone!   I have a couple of architects and developers telling me that Oracle is also a parallel database.  I fully understand the nature of Teradata's parallelism but do no...
10215 Sep 2014 @ 11:52 PDTDatabaseReplyError LogsFor load utility hope this helps...folder depends on your db release... for 14.10:   For Windows:     Program Files (x86)\Teradata\Client\14.10\Teradata Parallel Transporter\...
10105 Sep 2014 @ 05:38 PDTToolsTopicOMD API errorWe recently upgraded our TTU client on a Windows Data Services server from 14.00 to 14.10.  The TPT programs are patched to 14.10.00.05.  The server is Windows Server 2008 Enterprise SP1...
10007 Aug 2014 @ 10:04 PDTDatabaseTopicTDBenchV5Does anyone know if Teradata maintains the TDBenchV5 upgrade benchmarking app that was released back in 2010?  This package provides a framework for executing benchmarks driven by a Windows Se...
9907 Aug 2014 @ 09:50 PDTDatabaseTopicTD15.00 DBQL Migration ScriptsI have looked in the usual places for the DBQL migration scripts but do not see anything related to 15.0.  Does anyone know where these scripts are located or if they have been released? ...
9806 Aug 2014 @ 01:32 PDTDatabaseReplyFront-end object does not exist errorIf you are creating a table in SQL Assistant and do not include the databasename qualifier, the table will be created in the default database (your logon).  You can also set the databasename u...
9705 Aug 2014 @ 04:50 PDTDatabaseReplyFront-end object does not exist errorDid you code or set the database?
9601 Aug 2014 @ 04:24 PDTDatabaseTopicSemantic view Case statement over base table current_indHi all,   We have a history table in our base layer that is defined with a current_ind = Y/N.  A view has been created for the business in the semantic layer that redefines the current_...
9529 Jul 2014 @ 10:36 PDTDatabaseReplyPartition integer date key by monthThanks Raja!   The architects want to join the fact to the date dimension on the date key and then filter on the date in the date dimension.  The best I can get at that point is dynamic...
9428 Jul 2014 @ 05:14 PDTDatabaseReplyPartition integer date key by monthThank you... yes I did try that but was concerned about the partition being used if a cast is made.  Guess there is only one way to find out.  I will cast as a date and then see if I can ...

Pages