#DateForumTypeThreadPost
9325 Jul 2014 @ 02:40 PDTDatabaseReplyAvoid Product Join StepI will supply the lowest hanging fruit!  :-)   Statistics
9222 Jul 2014 @ 10:44 PDTDatabaseTopicPartition integer date key by monthHello All!   I am looking for a way to partition an integer by month.  The data type is integer and the values are 20140701, 20140702, etc.  We are joining to sys_calendar.EDW...
9107 Jul 2014 @ 04:36 PDTDatabaseReplyCan we able to perform all the ETL activites by using VIEWS ?????We have been very successful in switching some of the ETL processing out of a seriel ETL engine and into the parallel efficiency of the Teradata RDBMS.  In many instances we have accomplished ...
9027 Jun 2014 @ 04:24 PDTGeneralReplyHow can we rectify spool space issues.Sounds like your primary index might be skewed.  Remember, if you run out of space on one AMP it appears as though you have used up all available currentPerm in the database.  Plug your i...
8923 Jun 2014 @ 11:34 PDTDatabaseReplyQuery to Delete all the records in a table in TeradataJust a word or caution regarding the option of dropping the table and then re-creating...   When you re-create you need to also recreate the table and column comments.  More importantly...
8813 Jun 2014 @ 10:48 PDTToolsReplyBTEQ - Executing commands after .run file statementThanks Raja!   If I drop my script into a bteqwin window, it stops after the .run file command.  If I run the same script using a *.bat file (bteq < script.txt > script.out) all t...
8712 Jun 2014 @ 11:03 PDTToolsReplyBTEQ - Executing commands after .run file statementThis is similar to what I am trying to accomplish.  I cannot get any command to execute after the last .run file statement similar to what is in this script.  Is this a feature?   ...
8612 Jun 2014 @ 09:21 PDTToolsTopicBTEQ - Executing commands after .run file statementHi all,   I have created a bteq script that basically gathers a bunch of show table, show view, etc. statements and runs the file to create the ddl file.  I use this to perform mig...
8503 Jun 2014 @ 05:17 PDTDatabaseReplyTeradata Data MaskingWe have implemented a security table that seems to work pretty good. The table looks like this: CREATE MULTISET TABLE META_T.EDW_SECURITY ,NO FALLBACK ,      NO BEFORE JOURN...
8417 May 2014 @ 02:52 PDTDatabaseReplyTPT instead of FastLoadI was always under the assumption that the legacy load utilities (fastload, multiload, tpump,fastexp) would some day be depricated and that all new development would be added to the TPT utilities.&...
8313 May 2014 @ 01:56 PDTDatabaseTopicTables Missing StatisticsWe have implemented a process by which we call a stored proc after each table load that collects stats on the target table if currentPerm has changed by more than 10%.  Part of this process in...
8214 Apr 2014 @ 11:19 PDTData ModelingReplySurrogate vs business keysThanks Adeel... yes that does help.  I know what the books say... just looking for real world scenarios.  Many times I am presented with the argument:   "Surrogate keys should...
8109 Apr 2014 @ 09:42 PDTDatabaseReplyAdhoc AJII will admit... I got a little lazy and was looking for a quick answer!  :)  Anyway, I found my answer in the 'Database Design' manual.  For those that are interested in the ...
8008 Apr 2014 @ 04:56 PDTDatabaseTopicAdhoc AJIWe are in the process of creating a star schema to be used in an adhoc environment.  I have one fact table and five small dimensions of which one of them is the date dimension.  I created...
7902 Apr 2014 @ 01:15 PDTGeneralReplyHow we can replicate Tables structures between 2 teradata servers ?You could use Atana Suite Delta Tool.  Atana is like Toad for Teradata and has many tools that enhance productivity similar to your request.   You could SHOW the table in both environme...
7802 Apr 2014 @ 01:08 PDTDatabaseReplyNUPI and USI on the same columnJust a guess but maybe a NUPI on a set table with the possibility of duplicate row checks?  Of course the USI would cover that.  Maybe both are so fast it was a toss up!  Wish I had ...
7728 Feb 2014 @ 02:20 PSTViewpointReplyOne User Multiple LogonsThanks Tuen!  Yes... I was wanting to setup a generic id and let all users us it to log into Viewpoint.  Of course I tried that and it didn't work so I just wanted to verify that I wa...
7628 Feb 2014 @ 02:18 PSTDatabaseReplySQL to generate a column name listThank you for the recommendation Craig!   Joe
7526 Feb 2014 @ 02:12 PSTToolsReplyTTU 13.10I believe it is 4 backwards and 2 forward.
7426 Feb 2014 @ 01:46 PSTData ModelingTopicSurrogate vs business keysI know what the documentation generally states about using surrogate keys vs business keys, but I would like to know what everyone in the real world is doing.  I have a couple o...
7326 Feb 2014 @ 01:19 PSTDatabaseReplySQL to generate a column name listI use the following in order to get a list of columns names in the order they are defined in the table.  I use it to populate an insert/select when preserving data.   sel colu...
7226 Feb 2014 @ 01:08 PSTViewpointTopicOne User Multiple LogonsHi all,   Is there a way in Viewpoint to create one generic user called 'Monitor' that allows multiple logons at the same time?  If not, is the best way to accomplish this ...
7115 Feb 2014 @ 04:58 PSTDatabaseTopicOnline backup performanceGenerally speaking, can anyone tell me if online backups perform better than regular backups?  In other words, if I am backing up a 500gb table, which method would back up quicker, online or r...
7015 Feb 2014 @ 04:55 PSTDatabaseReplydynamic index collect stats statementThanks Dieter... works very nicely now!   Joe
6911 Feb 2014 @ 06:00 PSTDatabaseReplydynamic index collect stats statementFound it!.... IndexType!  I was pretty close to getting this to work.  I tried running the following: sel 'collect stats on ' || trim(databasename) || '.' || trim(ta...

Pages