#DateForumTypeThreadPost
7011 Dec 2012 @ 11:28 PSTToolsReplyRequest size exceeds maximum.Any resolution on this ? Facing the same issue :(
6906 Dec 2012 @ 10:04 PSTDatabaseReplySkewness in nopi TableIt has 15 nodes, loaded data using stream utility via Informatica..and issue is observed across tables with varying length..having 50000 rows to 10 million..
6805 Dec 2012 @ 01:25 PSTDatabaseReplySkewness in nopi Table:(
6704 Dec 2012 @ 02:05 PSTDatabaseTopicSkewness in nopi TableHi ,   I have table where loading data from flat files and all the tables appear to be skewed more than 95%. All these tables are no pi , Is there any way or reason why these tables would b...
6610 Oct 2012 @ 06:31 PDTGeneralReplyWhere is Teradata SQL AssistantTry Windows +R (Run ) and SQLA command
6519 Sep 2012 @ 02:51 PDTUDAReplyHow to exceute only integer records in character columnThrough direct supported SQL I can only think of recursive query. You will need to check from start of the string to length of the the string and if numberic than concatenate to existing data. If ...
6410 Sep 2012 @ 01:31 PDTToolsReplyFast Export 2GB file Limit I have worked on Linux server where we had files around 40 GB and it worked fine. Anyway for your case you might also want to explore pipe option in unix, to allow continous streaming ( if loadi...
6330 Aug 2012 @ 11:27 PDTGeneralReplyUpdate select optimization Check if update can be changed to left outer join of insert script of table A. Updates are usually heavy compared to Inserts. See if table is SET table ,on doing updates it might have to sca...
6217 Jul 2012 @ 02:40 PDTToolsReplyHow to write output of stored proc in a file using Fast Export You will have to check manuals to see if fast export actually suports procedural calls. I would not think so . If there is a simple select in procedure ( unlikely ) include it in the fast ex...
6117 Jul 2012 @ 02:34 PDTDatabaseReplyconvert varchar to date for 7/15/2012 If the same is not applicable for month as well, then you can check the size of the string and depending on it concatenate it with 0.    CASE WHEN CHAR_LENGTH(DATE_COL) <10 ...
6017 Jul 2012 @ 02:32 PDTDatabaseReplyNew to Teradata - Update a table with another records in same table UPDATE T1 FROM ( SEL DISTINCT DURATION ,... FROM TABLE T2 WHERE  ) T2 SET PROD_TYP_CD_FROM = T2.PROD_TYP_CD WHERE T1.MBR_DURATION = T2.MBR_DURATION + 1  ...
5902 Jul 2012 @ 09:07 PDTGeneralReplyHow do we calculate te cost of query in Teradata? I think you can measure it in terms of AmpTime
5828 Jun 2012 @ 11:01 PDTGeneralReplyHow to find out OS of Teradata box Its a 2 node system ,with one down ( back up node has kicked in though ). I am the one doing ETL :-)
5728 Jun 2012 @ 10:03 PDTGeneralTopicHow to find out OS of Teradata box One of ouy node is down and we need to figure out on which operatin system is our teradata box installed .  Any pointers would be appreciated . DBA is out for couple of days :) ...
5622 Jun 2012 @ 01:46 PDTGeneralTopicInformatica TPT issue Hi , I have a smiple mapping where I take data from Oracle database ,use expression transformation to add certain parameter values and then push it to teradata box. Now, it is running fi...
5511 Jun 2012 @ 10:02 PDTGeneralReplyIncomplete Query String in QueryText Column Thanks Ulrich .
5411 Jun 2012 @ 09:37 PDTGeneralTopicIncomplete Query String in QueryText Column Hi ,   I am working on TD 12 and noticed that DBC QRYLOG view and underlying DBQL table have incomplete query string in QueryText column ( around 200 chars ) even though datatype sh...
5306 Jun 2012 @ 02:46 PDTDatabaseReplyTo find invalid dates? You can also ofcourse use substring and check validity of year,month and day separately ,where you will have ot use case statements to check max value of allowed day.
5206 Jun 2012 @ 02:44 PDTDatabaseReplyTo find invalid dates? I think 9999 and 4712 might be the only exception not present in syscalendar you can perhaps manually override them . I do not suppose any database maintains valid data outside this century
5106 Jun 2012 @ 02:24 PDTDatabaseReplyNeed help with some handy code for this situation You will have to modify this considerable as per your records and use cases but in essence something like below should work /** Insert which will take care of your third row **/   ...
5006 Jun 2012 @ 01:43 PDTDatabaseReplyGroup by question Why don't you create separate temp table and then join to achieve desired result.    
4906 Jun 2012 @ 01:40 PDTDatabaseReplyNew_Calculation Field CSUM ?
4806 Jun 2012 @ 01:34 PDTGeneralReplyManual http://www.info.teradata.com/Datawarehouse/eBrowseBy.cfm?page=TeradataDatabase
4706 Jun 2012 @ 07:33 PDTGeneralReplyBteq script to read and execute query from a table 1: Export the output of the table in such a format that it beomces executable script and then call that script . 2: Use Export Reset command to achieve the same in one script.
4602 Feb 2012 @ 12:56 PSTUDAReplyCollect stats in ETL Many times collect stats are not required on daily basis .If you data doesn't change drastically,you can also consider having a separate fortnightly job collecting stats.

Pages