1021 | 01 Oct 2014 @ 12:29 PDT | Tools | Reply | Seeking Advice On Low Latency (Near Real Time) Loads using TPT and CDC | I 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,... |
1020 | 30 Sep 2014 @ 11:47 PDT | Database | Reply | How to find base tables/views for views | You can contact your TD poc in your org :)
|
1019 | 30 Sep 2014 @ 10:36 PDT | Database | Reply | How to find base tables/views for views | Teradata MDS , you can view. Do you have MDS?
|
1018 | 30 Sep 2014 @ 10:11 PDT | Database | Reply | Stored procedure | You 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 ? :)
|
1017 | 30 Sep 2014 @ 09:29 PDT | Database | Reply | How 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... |
1016 | 30 Sep 2014 @ 08:38 PDT | General | Reply | Executing insert statements stored in a table without stored proc | If 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 :)
|
1015 | 30 Sep 2014 @ 08:06 PDT | Analytics | Reply | Output to be concantenated & transposed | I 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... |
1014 | 30 Sep 2014 @ 09:58 PDT | General | Reply | Executing insert statements stored in a table without stored proc | you can use ....example:
insert into abc values(1)
;insert into def values('def')
;insert into hgi values('ddd',1);
|
1013 | 30 Sep 2014 @ 09:01 PDT | Database | Reply | DBC.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
|
1012 | 30 Sep 2014 @ 08:49 PDT | Teradata Applications | Reply | FastLoad process hang with concurrent sessions | I am bad in Windows env :) to be honest.
|
1011 | 30 Sep 2014 @ 08:32 PDT | Database | Reply | DBC.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
|
1010 | 30 Sep 2014 @ 06:11 PDT | General | Reply | HOW TO FIND THE FIRST 20 WORST RUNNING QUERIES LISTS IN TERADATA |
Viewpoint.....or running query : from table(syslib.MonitorSession(-1,'*',0)) AS TA
|
1009 | 30 Sep 2014 @ 02:19 PDT | Database | Reply | DBC.TABLES has truncated view defination in Requesttext field . How can i find full View defination . | Even DBC.TableText or DBC.tvm ?
|
1008 | 30 Sep 2014 @ 02:00 PDT | Teradata Applications | Reply | FastLoad 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.... |
1007 | 29 Sep 2014 @ 09:21 PDT | Database | Reply | Data redistribution | Your 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.
|
1006 | 29 Sep 2014 @ 09:15 PDT | Analytics | Reply | Output to be concantenated & transposed | You can use tdstats.udfconcat function.
|
1005 | 29 Sep 2014 @ 07:54 PDT | Database | Reply | Why 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... |
1004 | 29 Sep 2014 @ 03:36 PDT | Database | Reply | PRINT in Stored Procedure | I 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... |
1003 | 29 Sep 2014 @ 12:32 PDT | Database | Reply | Finding PI for a table created already | It 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,... |
1002 | 26 Sep 2014 @ 06:11 PDT | Database | Reply | Qualify in select statement | Because 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... |
1001 | 26 Sep 2014 @ 04:16 PDT | Database | Reply | Teradata Error 5533 | The 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... |
1000 | 26 Sep 2014 @ 03:30 PDT | Database | Reply | Teradata Error 5533 | Frod doucment:
5533 Too many MULTITSR Parcels.
Explanation:
The submitted Stored Procedure is too large to handle.
Generated By:
Pardrivr.
For Whom:
End User
Remedy:... |
999 | 26 Sep 2014 @ 01:14 PDT | Database | Reply | Text 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... |
998 | 25 Sep 2014 @ 10:51 PDT | Database | Reply | Text 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.
|
997 | 25 Sep 2014 @ 10:12 PDT | UDA | Reply | Query Tuning | I 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... |