#DateForumTypeThreadPost
3227 May 2013 @ 08:23 PDTDatabaseReplyData Distribution Skewthanks Shelley!
3125 May 2013 @ 05:20 PDTDatabaseReplyData Distribution SkewHi Experts, If the Table is small and having the records which are less than the no.of amps , then in this case , then skewness or improper distribtuion is bound to happen  across the amps. ...
3021 May 2013 @ 09:15 PDTToolsReplyStatistics collectionHi Raam, please see the resonses below- 1) the order of the columns doesnt matter during collecting stats on more than one column like collect stats on table_nm column (a,b) collect stats on ta...
2923 Apr 2013 @ 09:40 PDTDatabaseReplyTeradata and MainframeHi all, Can u pls suggest me some pointers to start with for JCL as I am bit new to it.   thanks in advance! Cheers! nishant
2821 Apr 2013 @ 10:28 PDTDatabaseReplyIs the popular opinion that DELETE ALL doesnt use the Transient Journal true?Hi Dieter/Fred, Just want to clear my doubt that if DELETE statement is the last/Only statement whether its a ANSI or  TD mode , it will always Omit the TJ .. Am I Correct here? Please corre...
2721 Apr 2013 @ 09:44 PDTThird Party SoftwareTopicInformatica supports teradata TIME STAMP WITH TIME ZONE or not??Hi Experts, I am getting an error during Informatica load into teradata column (TIMESTAMP WITH TIME ZONE) .. Input data in the Informatica is like '2011-09-09 12:12:12 2.333333 EUROPE/LONDON&...
2620 Apr 2013 @ 10:02 PDTDatabaseTopicJoining Strategy-Hi all, I was looking at the  various Joining strategies followed by TD optimizer like a) MERGE Join b) HASh Join c) Nested Join d) Exclusion Join e) Product Join when we think in terms...
2520 Apr 2013 @ 09:55 PDTDatabaseReplyType of Lock During a Multiple statement Request-Thanks Dieter for your pefect response.. Just  want to know the difference in type of lock applied at statement 3 in MSR vs BT ET .. In BT ET,  i understand it would be WRITE Lock at st...
2420 Apr 2013 @ 09:35 PDTDatabaseReplyFallbackHi  all, Based on the discusson above...I understand  that Permanent Journals and Fallback are independent of each other .There is no dependency as such on each other.... i.e a) we can ...
2320 Apr 2013 @ 09:44 PDTDatabaseReplyPermanent Journalshi all, I have a doubt related to the discussion above that is one permanent journal table is defined for the full db or it is defined per table or for  multiple tables.. ?   Also Diet...
2220 Apr 2013 @ 09:11 PDTDatabaseTopicType of Lock During a Multiple statement Request-Hi all, I have a doubt related to the type of locks during processing the no. of statements in a MSR,just want to clear it. for eg- BT INSERT INTO <tab_C> SELeCt.... ;   --statement ...
2117 Apr 2013 @ 08:58 PDTGeneralReplybteq repeatHi  Buddy, can you please share the solution.. i am bit curious to know how to handle this.... thanks! Cheers! Nishant
2017 Apr 2013 @ 08:41 PDTDatabaseReplyFULL PRIMARY INDEXHi  , FULL primary Index is refered in case of Conditional Deletes/Updates..not in the case of Insert/Select.. so dont worry abt that..   Cheers!
1917 Apr 2013 @ 07:53 PDTAnalyticsReplydifference between distinct and group byHi Santosh, Really very good explanation in distinct vs Group by but just want to add something that  from TD 12 onwards , teradata is recommending to always use a Group by in place of Disti...
1812 Apr 2013 @ 08:38 PDTAnalyticsReplyConvert Text to Proper Case is huge problme  Hi Dieter, Just asking out of curioisty that how to get and install that Oracle UDF package on a teradata system ..and can a developer do that or admin rights would be required f...
1710 Apr 2013 @ 10:35 PDTTrainingReplyNR0-012 Physical Implementation ExamHi Guys, In order to take the practice exams at coffindw, i tried to register it after completing the form but i  dont know why when i am clicking the FINISH button in the bottom,nothing is h...
1609 Apr 2013 @ 07:53 PDTDatabaseReplySpace consumed by Primary IndexHi Experts, In context to the above Question, just want to know how can we estimate the Size of the Secondary Index Subtable and also do we need to take in to account of Secondary Index sub table...
1503 Apr 2013 @ 07:34 PDTDatabaseReplyBest way to generate the Sequential numbers : CSUM or IDENTITY columns?Hi Dieter and Adeel, My REquirement is to get the Sequential with out any gaps.. does Identity column gives any gaps in between? which one is prefered for with out gaps? Cheers Nishant
1401 Apr 2013 @ 08:04 PDTDatabaseTopicBest way to generate the Sequential numbers : CSUM or IDENTITY columns?Hi Experts, My Requirement is to generate the Sequential numbers in Column .. As It can be done in two ways : A) define as identity column  b) CSUM(1,1)    but i got to know fr...
1327 Mar 2013 @ 07:58 PDTToolsReplyTPUMP for Active Ware housing Thanks Carlos for your reply.. so just got a doubt in mind that previous to TPT , in which load Utility in TD, active ware housing/Real time feed was supported?
1227 Mar 2013 @ 08:20 PDTToolsTopicTPUMP for Active Ware housing Hi Experts, As i have mostly worked on MLOAD/FLOADs, I have a bit confusion in usage of TPUMP in case of Real time/Active warehousing Processing and want to clear it.   As we will find that...
1127 Mar 2013 @ 05:36 PDTDatabaseReplyTIME (0) field converted to INTEGEROk Got it... thanks! So i belive If we execute the above tables in BTEQ then there wont be such kind of issues in creating TIME  datatype as there is no cocncept of ODBC connectivity in BTEQ....
1027 Mar 2013 @ 04:51 PDTDatabaseReplyTIME (0) field converted to INTEGERHi Dieter, Out of curiousity of the above problem ,  In order to change the Datetime format to AAA  in SQLA,  I went in Tools -->options-->General--> datetime format but ...
921 Mar 2013 @ 07:43 PDTDatabaseReplyhow know the table size ?Just to add more to the above Query -   Select Sum(Currentperm), vproc from DBC.Tablesize   where databasename ='abc' and tablename ='pqr' Group by Vproc;  
820 Mar 2013 @ 08:59 PDTDatabaseReplyPerformance considerations during taking back up--thanks Dieter!

Pages