#DateForumTypeThreadPost
44604 Jan 2014 @ 06:23 PSTGeneralReplyStrategic Vs Tactical queriesHi Cheeli, It is very common in DWH. TD manual has vividly described them, so I copy and paste from there: Tactical queries are short, highly tuned queries that facilitate action-taking or dec...
44504 Jan 2014 @ 05:36 PSTDatabaseReplyMODE and FORMAT - TD Utilities. Hi Raj, You have not shared your script. You have not shown the data. Have you tried with FORMAT FASTLOAD or even TEXT,VARTEXT MODE RECORD. Also you can try thus:   select C...
44404 Jan 2014 @ 05:08 PSTDatabaseReplyAccess Rights required to execute a FunctionAha!!!!Thanks Dieter. 
44304 Jan 2014 @ 02:16 PSTDatabaseReplyMODE and FORMAT - TD Utilities. In fastexport you can see the syntax as from manual:   FORMAT  FASTLOAD                BINARY          ...
44204 Jan 2014 @ 12:43 PSTData ModelingReplyWhat is a building block approach to building semantic data models? Views are nothing but can only be subset of what you want. The ultimate game is only what you want and security. However, there are times when we can't get what we want with views alone. The...
44103 Jan 2014 @ 09:35 PSTCloud ComputingTopicElastic Data Mart AnalyticHi, I feel that  Elastic Data Mart Analytic may help or replace  part of  Agile Methodology in DWH in  the future for an on-going project. I am not sure of enhancements. Chee...
44003 Jan 2014 @ 07:41 PSTDatabaseReplyWINCLI32.DLL is missing after installing javaHi Cheeli, As a first start, I suggest you go through this link and validate against all those checks. Maybe you can find something to sort out your issues. http://forums.teradata.com/forum/conne...
43903 Jan 2014 @ 07:27 PSTDatabaseReplyAccess Rights required to execute a FunctionHi VP, Maybe you can try   ALTER FUNCTION abcdefghi.HASH_MD5 EXECUTE NOT PROTECTED; Please let me know. Cheers, Raja
43803 Jan 2014 @ 03:04 PSTGeneralReplyPerformance Tuning Book RecommendationHi, I was under the impression that you are a newbie. For that reason I did mention about Database Design and some more docs. I can suggest then that you need to validate against those guidelin...
43703 Jan 2014 @ 02:36 PSTDatabaseReplyNested joins in TeradataCorrect. Cheers,
43602 Jan 2014 @ 11:06 PSTDatabaseReplyRemoving comma in a stringCheck your syntax properly. I can see a comma after col c and also why (col space c, col c).  
43502 Jan 2014 @ 10:52 PSTTrainingReplyNETBACKUP SOFTWAREHi, This material has a brief explanation of Netbackup with DSA. Maybe it is of interest for you. http://www.info.teradata.com/IndexedPdfs/133220007.pdf Cheers, Raja
43402 Jan 2014 @ 09:34 PSTDatabaseReplyRemoving comma in a stringYou have not explained with other columns. Let me assume that you can try thus: select oreplace (col1,',','')||oreplace (col2,',','')||oreplace (col3,','...
43302 Jan 2014 @ 09:14 PSTDatabaseReplyRegarding dbc.qrylogsql table's sqltextinfoI am not sure of plain text and .txt .Maybe your settings in SQL Assistant. Can you cast it to a varchar 64000 maybe and see if it works. Cheers, Raja
43202 Jan 2014 @ 08:58 PSTGeneralReplyPerformance Tuning Book Recommendation I think Teradata documents  are  good guide. As a newbie, I feel you can go step by step and see the beauty of the database. Each hiccup or problem is an opportunity to learn.The list ...
43102 Jan 2014 @ 08:40 PSTDatabaseReplyRegarding dbc.qrylogsql table's sqltextinfoHi Praveen, As far as I know, no. However, I think you cna do this way: create table tmp as(select sqltextinfo from dbc.qrylogsql ) with data;   Cheers and Happy New Year, Raja
43002 Jan 2014 @ 08:16 PSTDatabaseReplyRemoving comma in a string Did you try with oreplace function?   oreplace(column_name, 'string_to_replace','new_string') say: oreplace (col1,',','')   Cheers, ...
42902 Jan 2014 @ 07:12 PSTDatabaseReplyOrder of partition columns in MLPPI Page 301 of "SQL Request and Transaction Processing" describes with examples with MLPPI very nicely.They have taken a case of 65,535 partitions.
42802 Jan 2014 @ 06:41 PSTDatabaseReplyJoin two tables using like statementThey could have used a profiling tool. I am curious if any ETL tool is being used.  
42702 Jan 2014 @ 03:39 PSTDatabaseReplyJoin two tables using like statementHi , From the sample data you provide and join , I can see that you need to extract the string to match, like substr. This is going to be expensive. Just as a starting point you can think this jus...
42602 Jan 2014 @ 02:19 PSTGeneralReplySAY NO or NEVER to Agile Methodology in DWH project Blaine, I can think of an on-going DWH project where it branches out. But building it from beginning, I don't see much hope , since ROI will be high. Understanding business requirements ...
42502 Jan 2014 @ 01:25 PSTGeneralTopicSAY NO or NEVER to Agile Methodology in DWH projectBeing so much involved in Rally and updating daily the changes-- scrum meetings, let us play poker.....so many changes, I realize that Agile Methodology does not work for big DWH implementantion.&n...
42401 Jan 2014 @ 11:26 PSTDatabaseReplyComparison between DBQL AMPCPUTime and ResUsage CPU timesHi Mark, I am not strong in this area. However, I can see this link which provides directions and suggestions. http://forums.teradata.com/forum/database/thoughts-on-cpubusy-caclulations Cheers, ...
42301 Jan 2014 @ 08:23 PSTGeneralReplyIssue with MLOAD Error tables Did you check at TgtFiles directory or $PMTargetFileDir, If  not overridden at session connections level   control file has extension .ctl if I remember correctly.   ...
42201 Jan 2014 @ 07:19 PSTDatabaseReplyrecursive query numeric overflow issue Hi, Stored procedure has loop, cursor,do while,if else etc condition. There are lots of sample stored procedures in net.   Examples below are some snippets of code CREAT...

Pages