#DateForumTypeThreadPost
102101 Oct 2014 @ 12:29 PDTToolsReplySeeking Advice On Low Latency (Near Real Time) Loads using TPT and CDCI am always thinking of solutions :). Please bear with me, if it is out of place :)Teradata has recently acquired Think Big Analytics. Think Big Aanlytics has rich experience of integrating hadoop,...
102030 Sep 2014 @ 11:47 PDTDatabaseReplyHow to find base tables/views for views You can contact your TD poc in your org :)
101930 Sep 2014 @ 10:36 PDTDatabaseReplyHow to find base tables/views for views Teradata MDS , you can view. Do you have MDS?
101830 Sep 2014 @ 10:11 PDTDatabaseReplyStored procedureYou can use DDL,DCL in stored proc. Are you not breaching security when you pass password as parm? :). You can refer to the stored proc material. Why dont you try ? :)
101730 Sep 2014 @ 09:29 PDTDatabaseReplyHow to find base tables/views for views You can refer to an expert's solution: http://developer.teradata.com/blog/ulrich/2011/11/extract-and-analyse-database-object-dependencies   You can also think of exporting the result of...
101630 Sep 2014 @ 08:38 PDTGeneralReplyExecuting insert statements stored in a table without stored procIf you can make in the format suggested, you can execute in bteq or TD studio. If you use unix it is even easier, sed or vi editor ,use a little bit of excel programming :)
101530 Sep 2014 @ 08:06 PDTAnalyticsReplyOutput to be concantenated & transposedI see that you got it from the other post. Right? By the way, there are formatting options , when you want to format as "what you have " and "what you want as output"  I m...
101430 Sep 2014 @ 09:58 PDTGeneralReplyExecuting insert statements stored in a table without stored procyou can use ....example: insert into abc values(1) ;insert into def values('def') ;insert into hgi values('ddd',1);
101330 Sep 2014 @ 09:01 PDTDatabaseReplyDBC.TABLES has truncated view defination in Requesttext field . How can i find full View defination .Maybe this expert's articel helping you? I have not checked it . http://teradataforum.com/teradata/20060227_164410.htm
101230 Sep 2014 @ 08:49 PDTTeradata ApplicationsReplyFastLoad process hang with concurrent sessions  I am bad in Windows env :) to be honest.
101130 Sep 2014 @ 08:32 PDTDatabaseReplyDBC.TABLES has truncated view defination in Requesttext field . How can i find full View defination .If I am not wrong:  CreateTxtOverFlow = 'C' or RequestTxtOverFlow = 'R' . You can check these three tables DBC.tvm,DBC.texttbl,DBC.dbase, how they are joined
101030 Sep 2014 @ 06:11 PDTGeneralReplyHOW TO FIND THE FIRST 20 WORST RUNNING QUERIES LISTS IN TERADATA  Viewpoint.....or running query : from table(syslib.MonitorSession(-1,'*',0)) AS TA
100930 Sep 2014 @ 02:19 PDTDatabaseReplyDBC.TABLES has truncated view defination in Requesttext field . How can i find full View defination .Even DBC.TableText  or DBC.tvm  ?
100830 Sep 2014 @ 02:00 PDTTeradata ApplicationsReplyFastLoad process hang with concurrent sessions I have never loaded from SQL Server and do not have much idea. My opinion -----Anyone monitoring viewpoint? The link below gives an explanation on AXSMOD too if it helps. http://www.info.teradata....
100729 Sep 2014 @ 09:21 PDTDatabaseReplyData redistributionYour question is clear. I ran for some of my tables  Explain sel * I can see there is redistribution by hashcode. It looks like it is upto the optimizer and the data demography.
100629 Sep 2014 @ 09:15 PDTAnalyticsReplyOutput to be concantenated & transposedYou can use tdstats.udfconcat function.
100529 Sep 2014 @ 07:54 PDTDatabaseReplyWhy teradata is so difficult to use?Asagpariya, You are not alone. Generally speaking, anything new is a bit difficult. Enough help is there, much more than what you require, say, this link: http://developer.teradata.com/database/a...
100429 Sep 2014 @ 03:36 PDTDatabaseReplyPRINT in Stored ProcedureI think you come from oracle background, with dbms_output.put_line :).   Printing messages are like MESSAGE_TEXT , SELECT COUNT(*) INTO cnt FROM tab1; IF (cnt = 0) THEN SIGNAL SQLSTATE...
100329 Sep 2014 @ 12:32 PDTDatabaseReplyFinding PI for a table created alreadyIt seems you are aware of the query  to find skewness, so I will not re-iterate it. How skewed is your data? I m not sure if there is any tool that gives those details. However, if it is me,...
100226 Sep 2014 @ 06:11 PDTDatabaseReplyQualify in select statementBecause of your long list I could not comprehend the issue :) You want to sum the trasnsaction amount based on grouping of acct_id and sor_id and when it reaches 300 or more then you want to displ...
100126 Sep 2014 @ 04:16 PDTDatabaseReplyTeradata Error 5533The stored procedure body size of a stored procedure is limited to 6.4 MB in 14.10. But there is no limit on the stored procedure object code (compiled stored procedure) size. If this is not your...
100026 Sep 2014 @ 03:30 PDTDatabaseReplyTeradata Error 5533Frod doucment: 5533 Too many MULTITSR Parcels. Explanation: The submitted Stored Procedure is too large to handle. Generated By: Pardrivr. For Whom: End User Remedy:...
99926 Sep 2014 @ 01:14 PDTDatabaseReplyText File to load table I m more comfortable in Unix/Linux , using find :). In windows, you can just browse with a mouse and check where Teradata stuff is there.   It can be something like in this link only for the...
99825 Sep 2014 @ 10:51 PDTDatabaseReplyText File to load table You can use. One way is to write your script in notepad and store somewhere and execute. Make sure you are in the path or you configure path of mload/fload.
99725 Sep 2014 @ 10:12 PDTUDAReplyQuery TuningI think what he means to say is that we can use  windowed functions like max(xxxxxx) over(partition by yyyy order by ....)  and qualify with a condition.So rows are restricted. These...

Pages