101 | 15 Apr 2015 @ 02:57 PDT | Tools | Reply | Arcmain Estimates | Thanks. My env will be available primarily for arcmain. Also objects is just whole of databases. So parallel arcmain jobs will give more throughput?
|
100 | 02 Feb 2015 @ 12:55 PST | Tools | Topic | Arcmain Estimates | Hi,
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
|
99 | 25 Dec 2014 @ 11:03 PST | Analytics | Reply | Adding a row for a non existing transaction | Not 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... |
98 | 11 Dec 2014 @ 01:17 PST | Database | Topic | Change session Current date/timestamp to old date | Hi,
is it possible to change current_date or timestamp to old time for testing in bteq or SQLA
|
97 | 05 Dec 2014 @ 02:15 PST | Database | Reply | How to decide about Stats for new queries | Even high confidence MAY be collected. Its not mandatory. collect once, then check if they are used and improve performance. else remove.
|
96 | 05 Dec 2014 @ 02:13 PST | UDA | Reply | How we can use timestamp with timezone in teradata(Eqv to from_tz in oracle) | Thanks Dieter.
|
95 | 02 Dec 2014 @ 12:13 PST | UDA | Reply | How 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.
|
94 | 01 Dec 2014 @ 09:16 PST | Database | Reply | CREATE 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
|
93 | 27 Nov 2014 @ 11:58 PST | Database | Reply | Fast Load - doesn't load duplicate records in multi set table | Hi, Please refer http://forums.teradata.com/forum/tools/why-mload-accepts-duplicates-and-why-dont-fastload.
|
92 | 26 Nov 2014 @ 11:28 PST | Database | Reply | How to decide about Stats for new queries | No you cannot check from view directly.
|
91 | 26 Nov 2014 @ 11:24 PST | Database | Reply | Timestamp and date calculation | Thanks Dieter.
|
90 | 26 Nov 2014 @ 12:44 PST | Database | Reply | How to decide about Stats for new queries | Stats 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... |
89 | 20 Nov 2014 @ 10:29 PST | Database | Topic | Timestamp and date calculation | Hi ,
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... |
88 | 18 Nov 2014 @ 12:25 PST | Database | Reply | Time Zone String Instead of Offset | I 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'
|
87 | 18 Nov 2014 @ 12:05 PST | Database | Reply | How to decide about Stats for new queries | Adding 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.
|
86 | 13 Nov 2014 @ 02:52 PST | Database | Reply | To 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.
|
85 | 15 Apr 2014 @ 07:23 PDT | Database | Reply | Which is efficient? | and spool will remain same also? in TD14.
|
84 | 15 Apr 2014 @ 07:19 PDT | Database | Reply | Which 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... |
83 | 19 Mar 2014 @ 07:34 PDT | Database | Reply | ADD_MONTHS vs INTERVAL | SELECT ADD_MONTHS(CAST('2014-02-28' AS DATE )- extract (day from CAST('2014-02-28' AS DATE )) ,-6);
|
82 | 18 Mar 2014 @ 02:40 PDT | Database | Reply | How 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... |
81 | 17 Mar 2014 @ 06:41 PDT | Database | Topic | Converting SAS code to Teradata | Hello 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
|
80 | 13 Mar 2014 @ 10:02 PDT | Database | Reply | Correcting the corrupted record | first 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
|
79 | 13 Mar 2014 @ 06:51 PDT | Database | Reply | compression calculations | Bteq 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... |
78 | 27 Dec 2013 @ 06:35 PST | Tools | Reply | TPT Template operators with LDAP authentication | TPT 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.
|
77 | 27 Dec 2013 @ 06:13 PST | Database | Reply | extending MLPPI tables | Will defining empty partitions for future use have any impact on performance?
|