#DateForumTypeThreadPost
10115 Apr 2015 @ 02:57 PDTToolsReplyArcmain EstimatesThanks. My env will be available primarily for arcmain. Also objects is just whole of databases. So  parallel arcmain jobs will give more throughput?
10002 Feb 2015 @ 12:55 PSTToolsTopicArcmain EstimatesHi, Can we estimate time used for arcmain data copy/restore using linear scale from sample data? i.e. 5 gb is copied in 5 minutes then 1 tb in 1000 minutes. Regards, Harpreet
9925 Dec 2014 @ 11:03 PSTAnalyticsReplyAdding a row for a non existing transactionNot clear on what you are trying to acehieve. Please answer that how is monthly total calculated as it is not clear from example. why is it 2 in last row for outcome instead of 0. It seems th...
9811 Dec 2014 @ 01:17 PSTDatabaseTopicChange session Current date/timestamp to old dateHi, is it possible to change current_date or timestamp to old time for testing in bteq or SQLA
9705 Dec 2014 @ 02:15 PSTDatabaseReplyHow to decide about Stats for new queriesEven high confidence MAY be collected. Its not mandatory. collect once, then check if they are used and improve performance. else remove.
9605 Dec 2014 @ 02:13 PSTUDAReplyHow we can use timestamp with timezone in teradata(Eqv to from_tz in oracle)Thanks Dieter. 
9502 Dec 2014 @ 12:13 PSTUDAReplyHow we can use timestamp with timezone in teradata(Eqv to from_tz in oracle)Hi All, Is there function or standard code to convert UTC/GMT into PST with daylight saving.  
9401 Dec 2014 @ 09:16 PSTDatabaseReplyCREATE TABLE Failed [3737] Name requires more than 30 bytes in LATIN internal form???your tablename is more than 30 char.TN_ORDERLINE_DEPENDENCY_TYPE_LNDG .. please reduce below 30 and then create in both env. then let know if still issues
9327 Nov 2014 @ 11:58 PSTDatabaseReplyFast Load - doesn't load duplicate records in multi set tableHi, Please refer http://forums.teradata.com/forum/tools/why-mload-accepts-duplicates-and-why-dont-fastload.
9226 Nov 2014 @ 11:28 PSTDatabaseReplyHow to decide about Stats for new queriesNo you cannot check from view directly. 
9126 Nov 2014 @ 11:24 PSTDatabaseReplyTimestamp and date calculationThanks Dieter.
9026 Nov 2014 @ 12:44 PSTDatabaseReplyHow to decide about Stats for new queriesStats can be checked using help stats on base tables or using dbc table like statsV , statsinfo. running diagnostic helpstats give all stats that MAY improve query plan, but only few need to be se...
8920 Nov 2014 @ 10:29 PSTDatabaseTopicTimestamp and date calculationHi , Dieter once shared a nice article on timestamp, time and date calculation, i just misplaced link and not able to search it again on forum. If you have the link , please share. Regards harpr...
8818 Nov 2014 @ 12:25 PSTDatabaseReplyTime Zone String Instead of OffsetI dont fell there is timestamp format available to convert zone into string. You can have timezones converted to string using case statement. FORMAT 'YYYY-MM-DDBHH:MI:SS.S(F)Z'
8718 Nov 2014 @ 12:05 PSTDatabaseReplyHow to decide about Stats for new queriesAdding to what Rupesh said,  From explain daignostinc helpstats result. You should choose which stats to collect, not all are needed. Also more important are one with igh confidence.
8613 Nov 2014 @ 02:52 PSTDatabaseReplyTo remove special characters from a string Hi, if still on td 13, then position alongwith substr function can be used. position to identify position of special character in string and substr to dissect and concatanate strings.  
8515 Apr 2014 @ 07:23 PDTDatabaseReplyWhich is efficient?and spool will remain same also?  in TD14.
8415 Apr 2014 @ 07:19 PDTDatabaseReplyWhich is efficient?Does it mean that Tables can have any number of columns and this will not impact performance as long as select is retrieving few columns? select a1,a2,b3 from A join B on A.a1=B.b1 --A has 200 co...
8319 Mar 2014 @ 07:34 PDTDatabaseReplyADD_MONTHS vs INTERVALSELECT ADD_MONTHS(CAST('2014-02-28' AS DATE )- extract (day from CAST('2014-02-28' AS DATE )) ,-6);
8218 Mar 2014 @ 02:40 PDTDatabaseReplyHow to reduce skew factor on stage tables with NoPI?Hi Manju, Secondary index will not impact skew factor. Skew factor can be reduced by choosing more evenly distributed set of columns. if your 2% is going to one amp then you can find out what dis...
8117 Mar 2014 @ 06:41 PDTDatabaseTopicConverting SAS code to TeradataHello Everyone. I am looking for tool to convert SAS code to Teradata SQL. Please let me know if something is available in this respect.   Thanks Harpreet
8013 Mar 2014 @ 10:02 PDTDatabaseReplyCorrecting the corrupted recordfirst and third row are with same group (empno,ename, cod). question is not clear. are you looking SEL T.*, min(DW_EFF_DT) over (PARTITION BY EMPNO,ENAME,COD) from bbc T
7913 Mar 2014 @ 06:51 PDTDatabaseReplycompression calculationsBteq script can be used to calculate best options for MVC by considering datatypes, frequency of repeating values, distinct value count. This MVC list can then be reviewed for actual perm space sav...
7827 Dec 2013 @ 06:35 PSTToolsReplyTPT Template operators with LDAP authenticationTPT script needs to be modified manually to run with LDAP credentials.  I used to edit 2-3 lines to make it working. Please share the script.
7727 Dec 2013 @ 06:13 PSTDatabaseReplyextending MLPPI tablesWill defining empty partitions for future use have any impact on performance?

Pages