#DateForumTypeThreadPost
124627 Apr 2015 @ 08:17 PDTDatabaseReplyNeed help on Converting from Characters into IntegerI 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...
124527 Apr 2015 @ 01:39 PDTDatabaseReplyNeed help on Converting from Characters into IntegerWhat 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)....
124414 Feb 2015 @ 07:07 PSTGeneralReplyDECLARING VARIABLES INSIDE A STORED PROCEDURE LOOPThe 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...
124306 Feb 2015 @ 06:16 PSTDatabaseReplyMulti-Table Insert StatementsThis 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 ...
124203 Feb 2015 @ 07:46 PSTDatabaseReplyOrder 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...
124130 Jan 2015 @ 10:15 PSTToolsReplyLoading data files from hadoop to teradata using TPTThis 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...
124030 Jan 2015 @ 08:16 PSTDatabaseReplyTransfer compressed dataYou 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.
123930 Jan 2015 @ 05:25 PSTDatabaseReplybteq utility query on TD databaseIt 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...
123830 Jan 2015 @ 04:49 PSTGeneralReplyTeradata-Combine multiple rows of a column to multiple columns in a rowOne 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...
123727 Jan 2015 @ 02:51 PSTDatabaseReplySkew Factor & StatsYou dont need to refresh. I think you come from Oracle background, where you see materialized view, where  you can refresh.
123626 Jan 2015 @ 11:21 PSTDatabaseReplySkew Factor & StatsHi, 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 ...
123526 Jan 2015 @ 10:05 PSTDatabaseReplykeep the data last recod of the grouppI 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,...
123426 Jan 2015 @ 09:27 PSTGeneralReplyRestore the loaded source data files in backup folderAre 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 .
123323 Jan 2015 @ 11:28 PSTDatabaseReplyEncryption in TeradataIt 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...
123223 Jan 2015 @ 05:32 PSTDatabaseReplyDisk IOs in Teradata 14.10You can get more infor by including username too and then  drill further to dbql tables... 
123122 Jan 2015 @ 10:12 PSTDatabaseReplyFinding the nearest greater date lookup through SQLI 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...
123022 Jan 2015 @ 12:28 PSTDatabaseReplyTransposing the columnsMaybe 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
122921 Jan 2015 @ 10:41 PSTGeneralReplyQuery about Materialisation of queries based on viewsPerchance,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...
122821 Jan 2015 @ 10:22 PSTDatabaseReplyDynamic Table NameYou 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, ...
122721 Jan 2015 @ 10:09 PSTDatabaseReplyEncryption in TeradataEncryption 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...
122621 Jan 2015 @ 10:01 PSTDatabaseReplyTransposing the columnsTry with select tdstats.udfconcat(input1) from yourtable; You can remove the unwanted " and , using regexp_replace....
122520 Jan 2015 @ 12:43 PSTCloud ComputingReplyTD 14.10 for AWS EC2Hope this link helps:  http://developer.teradata.com/database/articles/teradata-express-14-0-for-ec2-config-guide
122419 Jan 2015 @ 08:29 PSTGeneralReplyReg : Performance of Coalease in Select StatementI 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...
122319 Jan 2015 @ 06:09 PSTGeneralReplyReg : Performance of Coalease in Select StatementMany 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 ...
122216 Jan 2015 @ 08:42 PSTDatabaseReplyHow 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 :)

Pages