1121 | 29 Oct 2014 @ 08:28 PDT | Tools | Reply | BTEQ export CSV issue | Try to cast each field.
This example may help you.
https://forums.teradata.com/forum/database/help-needed-in-bteq-export
|
1120 | 29 Oct 2014 @ 07:31 PDT | General | Reply | Is Teradata good for Operational Online Applications | I did not work with Java team in one project,I had worked before . But I never heard any complaint from there. I never coded online applications with Teradata.
Just my curiosity.Are they using MyB... |
1119 | 29 Oct 2014 @ 01:32 PDT | Database | Reply | Date field behaving different in different environment | Even if you choose/set as below?
SET SESSION DATEFORM = ANSIDATE
= INTEGERDATE
|
1118 | 28 Oct 2014 @ 11:04 PDT | General | Reply | How to check any STATS being used by a query/queries or not? | Carrie's blog---STATSUSAGE, XMLPLAN......if it helps
http://developer.teradata.com/blog/carrie/2013/12/easing-into-using-the-new-autostats-feature
|
1117 | 28 Oct 2014 @ 07:08 PDT | Database | Reply | Cpu and io skew -99% | Maybe you can share the query? Joins of tables, if can be tweaked meeting the end requirements.
Also, if logics can be broken up VT, GTT. How about temporal features too? I see date comparis... |
1116 | 28 Oct 2014 @ 06:54 PDT | General | Reply | what are the drawbacks by using join index table? | You could have read the doc :)
Join indexes can be expensive to maintain.
Each time a join-indexed base table column is updated or deleted, the corresponding join index table ... |
1115 | 28 Oct 2014 @ 06:43 PDT | General | Reply | If we create a 32 secondary indexes on table what might be the performance | Creating a secondary index causes the system to build a subtable to contain its index rows, thus adding another set of rows that requires updating each time a table row is inserted, deleted, or upd... |
1114 | 27 Oct 2014 @ 11:37 PDT | Training | Reply | Pointers for TD Certification | My suggestion is , based on the content and context of certification and referring to the release notes, you go specific to the features of utilities, tools..db in detail. The questions may not be ... |
1113 | 27 Oct 2014 @ 11:16 PDT | Database | Reply | Cpu and io skew -99% | Initial thought:
Without much info,just the explain, a quick glance, looks like your OR clause. How about replacing with IN? Modeling is one part , where I see that should have been taken care w... |
1112 | 27 Oct 2014 @ 10:10 PDT | Data Modeling | Reply | Casting integers.... | Do you mean?
CAST(BlgPrdSvcCd as integer) and not as CAST(BlgPrdSvcCd as int) |
1111 | 27 Oct 2014 @ 10:10 PDT | Database | Reply | Hadoop threat to data warehouse vendors |
My opinion:
Not at all a threat. Rather, it is creates a plethora of opportunities.There are tens of thousands of writes-up on the web.
But those who made comments, may not have gone deep or... |
1110 | 27 Oct 2014 @ 05:29 PDT | Database | Reply | write SQL UDF in Teradata | That is what they are made of. Love unix and C programming too but I choose java here.For example, there are few udfs I made in java, say like search for a pattern. Compile that java code. Create a... |
1109 | 27 Oct 2014 @ 03:24 PDT | Database | Reply | write SQL UDF in Teradata | I think it is better for your case to write in java or c or c++.
http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1147_111A/ch04.059.06.html, even examples are... |
1108 | 26 Oct 2014 @ 09:27 PDT | Database | Reply | TSET Collection | Maybe you can try with GTT. However, the materialized contents cannot be shared across. It may or may not be accurate as per your reqt or you can simulate the same thing of a VT :) |
1107 | 23 Oct 2014 @ 09:43 PDT | General | Reply | Need Help with Query | Need to be careful with data type:
select id,id1,
max(coalesce(key1,0))over(partition by id,id1 order by id,id1 rows between unbounded preceding and unbounded following) k1,max(coalesce(... |
1106 | 23 Oct 2014 @ 08:38 PDT | Database | Reply | Load Different DATE formats into Teradata | If your target is varchar, it can be in any format. In some cases, you need to cast.
|
1105 | 23 Oct 2014 @ 08:05 PDT | General | Reply | setting a parameter inside of a bteq script | In Unix/linux, you can use say for example : export DB_NAME=DB1 inside the script
|
1104 | 22 Oct 2014 @ 11:46 PDT | Tools | Reply | Hiding password in mload script | You can read this article:
http://developer.teradata.com/tools/articles/introducing-teradata-wallet
|
1103 | 22 Oct 2014 @ 09:17 PDT | Database | Reply | TD_UNPIVOT throwing error: SELECT Failed. [9134] TD_UNPIVOT_CONTRACT; Help is confusing | You can work out with query. You can test with sample data of what you have and what you want to achieve, you can tweak.
|
1102 | 22 Oct 2014 @ 08:33 PDT | General | Reply | OReplace vs. Case Statement | You can check this and see, implementing with your case when:
select regexp_replace('10=Very Satisfied','[^0-9]+','',1,0,'i')
|
1101 | 22 Oct 2014 @ 06:48 PDT | General | Reply | OReplace vs. Case Statement | I am not clear with what you want. Can't assume much :).However, you can use an oreplace within another oreplace.. You can use oreplace in conjuction with case stmt based on your requirem... |
1100 | 22 Oct 2014 @ 01:05 PDT | Database | Reply | Any good Teradata Material | I think you can post under Training :)
You can go through this link and directions are provided with hyperlinks.
http://forums.teradata.com/forum/training/terdata-certification-in-india
|
1099 | 21 Oct 2014 @ 07:42 PDT | Database | Reply | Teradata query tunning | My suggestion is to tweak at BO side, join properties. Try to replace IN with = wherever possible. Think of how you can recode this : IN ('-ALL-') OR '-ALL-' IN (... |
1098 | 20 Oct 2014 @ 11:57 PDT | Database | Reply | Load utilities Limit in TASM | Hi Sandeep,
The admin will inform you.
Cheers,
Raja
|
1097 | 20 Oct 2014 @ 11:36 PDT | Database | Reply | How can i find actul uncompress size of BLC Compress table | Ferret's commands aplenty, showblocks, showcompress......estimate....
Need to balance the IO and CPU :).
If you need to see the size of table, then dbc.tablesize.
|