#DateForumTypeThreadPost
32114 Dec 2013 @ 06:11 PSTAnalyticsReplyWhy UV in MLOAD?Hi Sankalp, Nice question. To all intents and purposes, a software or automation or technology  is made to serve business. A software or automation that takes care of all business cases or ev...
32013 Dec 2013 @ 07:22 PSTGeneralReplyGROUP BY CUBE or ROLLUP how to use it?Hi Milan, I have never experimented GROUP BY CUBE. Teradata has Aggregate designer and OLAP connector etc.  like  http://developer.teradata.com/tools/articles/the-rolap-easy-button-an-i...
31913 Dec 2013 @ 07:31 PSTDatabaseReplyRESERVED WORDS: Query to identify reserved words in procedure Hi Reddy, You are welcome. Did you check in the forum , if someone has done similar task? I know it is painful if the volume is high. Good luck. Raja
31813 Dec 2013 @ 06:58 PSTDatabaseReplyvproc types Hi Dieter,   The material:   Node vproc: The node vproc handles PDE and operating system functions not directly related to AMP and PE work. Node vprocs cannot b...
31713 Dec 2013 @ 02:26 PSTDatabaseTopicvproc typesHi, I can see 7 vproc types(columns..I mean) in DBC.ResUsageIpma? As far as I know, we have only 6 types. May I know what is the 7th one?   Thanks and regards, Raja
31613 Dec 2013 @ 01:57 PSTDatabaseReplyHow to grant UPDATE to DBC on DBC.IDCol Tables?Hi Kawish, It is a riddle now for me since you connect with DBC and you get an error. I am not sure, however when I run this query: SELECT * FROM DBC.AllRightsV where tablename='IDCol';, ...
31512 Dec 2013 @ 10:42 PSTDatabaseReplyRESERVED WORDS: Query to identify reserved words in procedure Hi Reddy, For now I can think of  is take show procedure for all procs into a file. Then I will match through some programs either unix(my favourite :)) or excel progamming against values fro...
31412 Dec 2013 @ 10:19 PSTDatabaseReplyCollect stats doubtHi Aravind, This link maybe old but it gives vivid explanation why indexes are used. Statistics are collected for the goal of performance. We need to be careful when we choose columns for collect ...
31312 Dec 2013 @ 12:13 PSTGeneralReplyFastload Error Table 2Even you can try with NOPI tables as staging, it can be faster and then load to target table . Cheers, Raja  
31212 Dec 2013 @ 12:08 PSTGeneralReplySame query taking different CPU TIME, RESPONSE TIMEHi, Did you have a look at the DBQL tables? Cheers, Raja
31111 Dec 2013 @ 10:41 PSTTeradata ApplicationsReplyFASTLoad to load UK companies house dataAlso just my suggestion: Please share the data (at least sample or reasonable mask) besides logs and errors to avoid delay in response. Cheers, Raja
31011 Dec 2013 @ 10:36 PSTDatabaseReplyMacro Metadata Log TableOk thanks and now that you have seen, you can  implement the way according to your convenience. Cheers, Raja
30911 Dec 2013 @ 09:17 PSTDatabaseReplyBteq script - error handling not working, need helpHi Ratnam, Can you try with this: select fields you want where tablename='target' and date='your date' and status='your status' then check the activity count for the abov...
30811 Dec 2013 @ 08:56 PSTData ModelingTopicLineageHi, Can someone share some thoughts on lineage tools for enterprise like BRE say? Previously I modeled meta independent of any tool. But in case someone has better experience, they can share, t...
30711 Dec 2013 @ 08:48 PSTAnalyticsReplyjoin indices Hi Sankalp,   We make join table for a purpose(s) especially performance to serve business reqt.It can be Join of large table with another one to get only reqd fields, frequently ac...
30611 Dec 2013 @ 08:23 PSTUDAReplyStored Procedure Execution via Unity Hi, I am curious here since I work in both Teradata and Oracle. I have never seen a code in Teradata proc having execute immediate. Is it there even if you could execute them independent of Unity?...
30511 Dec 2013 @ 08:14 PSTDatabaseReplyMacro Metadata Log TableHi, Maybe you can just filter out what you want in another table.  By the way, if you can share the objective and ideas or the reason why you are doing this(only macro maybe), then others ca...
30411 Dec 2013 @ 07:43 PSTExtensibilityReplyDateTime format in XMLELEMENT functionHi Andy, I  run this code: select cast(current_timestamp as TIMESTAMP(6) WITH TIME ZONE); Also I pull from my document  this info:              ...
30311 Dec 2013 @ 01:43 PSTTrainingTopic(Training) Cloudera Certified Hadoop professional Hi, Anyone knowing about how and where to undergo training in Bangalore for Cloudera Certified Hadoop professional ? Those who have cleared the certification, can you please share some ideas?...
30210 Dec 2013 @ 08:45 PSTDatabaseReplyMerge statement showing 0 records mergedHi Soumik, Why don't you paste the code here in all four cases with data so that we can have a look. Of course, I dont have login to unix box, but others who can test , can give an opinion. ...
30110 Dec 2013 @ 07:33 PSTDatabaseReplyRewriting the Self joinHi Bikky, My thought is that the first select  within the derive is enough.Do I miss anything here, due to slight astigmatism :) ? Why don't your see the explain and validate the data too...
30010 Dec 2013 @ 07:22 PSTDatabaseReplyUTF -8 or UTF-16?Hi Nishant, Will this function help you? I ran two  cases  select octet_length('Amazon Web services',UTF8) UTF8_byte,octet_length('Amazon Web services',UTF16) UTF16_byte...
29909 Dec 2013 @ 11:14 PSTGeneralTopicDQ FRAMEWORK and ETL framework Hi,   Does anyone have DQ framework and ETL framework template? I am looking for multi-stream sources with one continuous  web-based source.My design is source-ods-staging-edw-...
29809 Dec 2013 @ 11:04 PSTDatabaseReplyMacro Metadata Log Table Hi, You ca get most of the info from DBQLogTbl,DBQLObjTbl,DBQLStepTbl and some other DBQL tables if you need extra. Now-a-days, even ETL meta tables design have become easier. ETL framework,...
29708 Dec 2013 @ 11:04 PSTDatabaseReplyDefault date column not aligning in xcel Excel does have an issue with dates before 1900. However, there is a workaround for it. This script, I test in excel and it works fine with few extra values: http://support.microsoft.com/?kb...

Pages