1246 | 27 Apr 2015 @ 08:17 PDT | Database | Reply | Need help on Converting from Characters into Integer | I dont get it when you have 123 twice in target.
I dont know if I understand it correctly. It looks like you have to check with regex and case when statement in a subquery. Then percha... |
1245 | 27 Apr 2015 @ 01:39 PDT | Database | Reply | Need help on Converting from Characters into Integer | What is the logic behind that you conclude that ABCD is 1, ACD is 2 and BDE is 3 and so on and so forth? Or is it that you want to provide a row number for each( where you can solve by row_number).... |
1244 | 14 Feb 2015 @ 07:07 PST | General | Reply | DECLARING VARIABLES INSIDE A STORED PROCEDURE LOOP | The document:
You must define a host variable between BEGIN DECLARE SECTION and END
DECLARE SECTION statements.
It is a good practice to compartmentalize the code for ease... |
1243 | 06 Feb 2015 @ 06:16 PST | Database | Reply | Multi-Table Insert Statements | This is just my opinion.
I don't think Oracle insert all is great. The question of restartability is there. If it rolls back for a huge amount of data in the middle????. Think about a failure ... |
1242 | 03 Feb 2015 @ 07:46 PST | Database | Reply | Order By Result Difference in TD and DB2 Using Dense_Rank() Function with it | I am not an expert in DB2. However, I think you can refer to this link and its explanation on order by and compare with that of DB2.
http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#p... |
1241 | 30 Jan 2015 @ 10:15 PST | Tools | Reply | Loading data files from hadoop to teradata using TPT | This link maybe of help : http://developer.teradata.com/connectivity/articles/teradata-connector-for-hadoop-now-available
I am thinking people are using hadapt, because it can bifurcate works... |
1240 | 30 Jan 2015 @ 08:16 PST | Database | Reply | Transfer compressed data | You can have a look at DSA too, since it is better than ARC and TARA. It works for 14.10 version and later. Hope you can do it thru Unity too.
|
1239 | 30 Jan 2015 @ 05:25 PST | Database | Reply | bteq utility query on TD database | It needs unix/linux working knowledge. You can try in windows env too.
After login declare one empty file, run file.
label each dml for ease of retrieval.
perform your dml
check err... |
1238 | 30 Jan 2015 @ 04:49 PST | General | Reply | Teradata-Combine multiple rows of a column to multiple columns in a row | One way is you can try something like this and use substring to get each field and give an alias name:
select name1,regexp_replace(tdstats.udfconcat(trim(dept1)||','||trim(salary)),'&q... |
1237 | 27 Jan 2015 @ 02:51 PST | Database | Reply | Skew Factor & Stats | You dont need to refresh. I think you come from Oracle background, where you see materialized view, where you can refresh.
|
1236 | 26 Jan 2015 @ 11:21 PST | Database | Reply | Skew Factor & Stats | Hi,
You can have a look at this link(look till the end):
http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/Database_Management/B035_1094_111A/ch09.050.139.html
One way ... |
1235 | 26 Jan 2015 @ 10:05 PST | Database | Reply | keep the data last recod of the groupp | I am assuming that the ones in bold are the required (ones). How do you get the 5,6 lines. I am thinking that the 6th line is 123 abc 2014 5000.
Try something thus:
select Mbr_num,... |
1234 | 26 Jan 2015 @ 09:27 PST | General | Reply | Restore the loaded source data files in backup folder | Are you using Susie Linux?
See if you can run upstream jobs to reproduce the files.
Talk to Unix/Linux admin to recover the files. eg:With debugfs , inode, you may get back .
|
1233 | 23 Jan 2015 @ 11:28 PST | Database | Reply | Encryption in Teradata | It has. You can go through this link and see FDE. I thin this is what you are looking for.
http://www.info.teradata.com/edownload.cfm?itemid=140900012
It is chapter 9, where you can see pas... |
1232 | 23 Jan 2015 @ 05:32 PST | Database | Reply | Disk IOs in Teradata 14.10 | You can get more infor by including username too and then drill further to dbql tables...
|
1231 | 22 Jan 2015 @ 10:12 PST | Database | Reply | Finding the nearest greater date lookup through SQL | I am not clear when it is "nearest-greater-date-lookup-through-sql". A quick look at the expected output looks like, row ordering and case when statement can be conditioned according as r... |
1230 | 22 Jan 2015 @ 12:28 PST | Database | Reply | Transposing the columns | Maybe this example can help you:
http://forums.teradata.com/forum/analytics/merge-a-variable-number-of-rows-with-one-column-into-a-single-row-0#comment-135486
|
1229 | 21 Jan 2015 @ 10:41 PST | General | Reply | Query about Materialisation of queries based on views | Perchance,if you are okay, you can share the reasons why you resort to physical storing. It looks like you have joins of complex views in semantic and you want to store that way,and it is one-off a... |
1228 | 21 Jan 2015 @ 10:22 PST | Database | Reply | Dynamic Table Name | You can put your bteq script in a unix script and pass unix date to your create table or you can pass it as parameter from your unix script.
Another choice, to avoid this , you may have SVN, VSS, ... |
1227 | 21 Jan 2015 @ 10:09 PST | Database | Reply | Encryption in Teradata | Encryption can be when you do backup to tapes....
You can develop UDFs as per your requirement too. There are tools available , working along with teradata and hadoop too.
For cl... |
1226 | 21 Jan 2015 @ 10:01 PST | Database | Reply | Transposing the columns | Try with select tdstats.udfconcat(input1) from yourtable; You can remove the unwanted " and , using regexp_replace....
|
1225 | 20 Jan 2015 @ 12:43 PST | Cloud Computing | Reply | TD 14.10 for AWS EC2 | Hope this link helps:
http://developer.teradata.com/database/articles/teradata-express-14-0-for-ec2-config-guide
|
1224 | 19 Jan 2015 @ 08:29 PST | General | Reply | Reg : Performance of Coalease in Select Statement | I suggest you have a look at this link, about coalesce:
http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1145_111A/ch02.072.57.html
Run explain and see the st... |
1223 | 19 Jan 2015 @ 06:09 PST | General | Reply | Reg : Performance of Coalease in Select Statement | Many conversion functions!!!! After all , it has to undergo conversion and it is software and not magic. It will hit performance. If it is me, I will study the source system well and decide what I ... |
1222 | 16 Jan 2015 @ 08:42 PST | Database | Reply | How to achieve the below output in teradata? | Can you please tell a so-to-say user story or use case of how you arrived at result set 1 and result set 2? It will be interesting :)
|