#DateForumTypeThreadPost
19614 Nov 2013 @ 08:07 PSTToolsReplyInstalling BTEQ / MLoad on Windows 7Hi, This is taken from this link of TD:   Download the Teradata Studio Express zip file from the download site. It may help you: http://downloads.teradata.com/download/tools/teradata-s...
19514 Nov 2013 @ 07:53 PSTToolsReplyUtilities interacting with mloadKhurram, The question is pretty clear :).  Cheers, Raja
19414 Nov 2013 @ 04:22 PSTToolsTopicUtilities interacting with mloadHi, May I know what are the TD utilities interacting with mload? Thanks and regards, Raja
19314 Nov 2013 @ 02:42 PSTExtensibilityReplyTeradata Appliance for HadoopHi, I am also curious if this is different from Aster. Thanks and regards, Raja
19213 Nov 2013 @ 10:15 PSTDatabaseReplyTools to compare two teradata's DB and find the differences Hi, Will this one help you? I love unix , so I always do it in bteq, exporting to a file and then do the work. Below script not tested.     select case when tablekind = ...
19113 Nov 2013 @ 09:57 PSTAnalyticsReply-----Aggregate Designer----Hi Gryback, Thanks. I saw this. I am looking more at the advantages and disadvantages to justify. People have come to me with ifs and buts and I could not justify much on this. Thanks a lot Gryba...
19013 Nov 2013 @ 09:47 PSTDatabaseReplyHave NULLs in DATE fields always been possible?Hi, It should allow NULL. All DBs should allow NULL else they dont represent business cases. I think it is in the mind of the designer to put 1111-11-11 just to be on the safer side.  There ...
18913 Nov 2013 @ 09:19 PSTDatabaseReplyManual Data profiling queriesHi Nagesh, I used Teradata Profiler and Ab Initio Data profiler before. However, manual is a real pain. Few years back, I used manual . Believe me it is a pain. I used unix script too some...
18813 Nov 2013 @ 01:35 PSTCloud ComputingTopicTeradata’s cloud-based Integrated Marketing Management Hi, Anyone has implemented Teradata’s cloud-based Integrated Marketing Management ? Can anyone share some information with me, about infrastructure etc requirements and how does it resp...
18713 Nov 2013 @ 12:23 PSTGeneralReplyHow to write FIRST_VALUE() and LAST_VALUE() window function in Teradata? Hi, I am not pretty sure of the way first_value function works with NULL etc. There maybe Null VALUES too. If it is me to be on the safer side and to meet business requirements, then I would take...
18612 Nov 2013 @ 11:12 PSTDatabaseReplyProblems with dynamic creation of Volatile tables Hi,   You can create index on volatile table. I am not pretty sure also if it applies the same that a min of 512 bytes perm space be assigned for a user or db for table header; ...
18512 Nov 2013 @ 09:18 PSTDatabaseReplyProblems with dynamic creation of Volatile tablesHi, Are you querying using the same session? Cheers, Raja
18412 Nov 2013 @ 08:56 PSTData ModelingReplyCan Teradata display the Quarter value of a date?Hi , You can use quarter_of_year or  quarter_of_calendar columns in sys_calendar and then join with your table. Cheers, Raja
18312 Nov 2013 @ 07:56 PSTExtensibilityTopicTeradata Appliance for HadoopHi, How is Teradata Appliance for Hadoop different from DM Aplliance, Extreme DA, DW DA and AEDW? Is it specifically for Hadoop only or it can contain all? And how does it relate to Aste...
18212 Nov 2013 @ 07:50 PSTDatabaseReplyRecursive queryHi Arindam, I dont have access to Teradata. I have one free oracle online server. So I tried with that for solutions, since I work on other Databases too. I dont know if I can have a Teradata onli...
18112 Nov 2013 @ 01:26 PSTToolsTopicAllocate memory for TD profilerHi, How do I allocate memory for a Teradata Profiler job and some more parameters? I used to work on this tool 2 years back and I forgot it. (Used to work before in Ab Initio Profiler.I know how ...
18011 Nov 2013 @ 11:26 PSTAnalyticsTopic-----Aggregate Designer----Hi, What are the advantages of having Teradata OLAP Connector,Aggregate Designer, Schema Workbench when I can use other reporting tools that come handy with all features, including middle tier ...
17911 Nov 2013 @ 10:34 PSTDatabaseReplyCase statement not pulling time between 18:31:01 and 19:00:00 Hi,   How about beyond 18:31 and 19:00? Next time, if you dont mind, when you paste your result set, please put in a proper format so that it will be easy to see.   ...
17811 Nov 2013 @ 09:04 PSTAnalyticsReplyData level security using queryHi Arindam, I look from  many perspectives, infrastructure etc etc. Every reporting tool allows you to write and manipulate code with drag and drop and put the logic you want. However, I feel...
17711 Nov 2013 @ 08:53 PSTDatabaseReplyRecursive query Hi Arindam,   Yes a recursive query will do the work.   Have you tried with a self join of the table and then concatenate to get the desired result. It is a hierarchica...
17611 Nov 2013 @ 08:13 PSTAnalyticsReplyData level security using queryHi Arindam, I dont have Td access. However, I see that you can use something like(just a logic sort) select dim.d1,dim.d2..,case when dim.cnt>=8 then dim.cnt else null from (select dim2...
17511 Nov 2013 @ 05:46 PSTDatabaseReplyMove column data as rows Hi,       create table then select  The query:   SELECT NAME as ID FROM tabl1---note here I want to  get the col as you want UNION ALL ...
17410 Nov 2013 @ 10:52 PSTAnalyticsTopicTeradata-OLAP-ConnectorHi, Can I use Teradata-OLAP-Connector with excel 2007 when my ram size is 2 GB? Thanks and regards, Raja
17310 Nov 2013 @ 10:22 PSTTrainingReplyAb Initio Online TrainingHi, How about ICFF, plan, continuous, message queues, code promotion scripts and tools, data profiler  and many more advanced features 3.1... The reason I am asking is for reference if anyon...
17210 Nov 2013 @ 10:17 PSTTeradata StudioReplyTeradata Studio User GuideHi , Does it have examples too there like wht we have in Adminsitartor? Thanks and regards, Raja

Pages