#DateForumTypeThreadPost
122115 Jan 2015 @ 08:26 PSTDatabaseReplySpool space issueFew things to look at: Is any of  the group by field a lengthy or oversized varchar? You can check the explain of your select part by part and fix the issues. See if you can use exists inste...
122009 Jan 2015 @ 10:24 PSTDatabaseReplyChange data capture Few ideas that crop up in my mind :)   100 columns!!!! Comparing all columns, source and target, database resource consumption will be high.Of course , if necessary(very rarely), yo...
121909 Jan 2015 @ 04:12 PSTAnalyticsReplycreate SDC from a history tableaamer123, You can check with this.... if it helps. select * from (select col1,min(start1)over(partition by col1,stat1 order by  col1,stat1) st, max(end1) over(partition by col1,s...
121805 Jan 2015 @ 07:19 PSTGeneralReplySum Of Squares OperatorTry with this example if I understand correctly.  select  12**2------ ( 144) select 12**3 -----(12*12*12)
121705 Jan 2015 @ 04:47 PSTDatabaseReplyHow to identify the unused stats in a query.Collecting stats on all columns unneccesarily does not make sense. I suggest you refer to this similar discussion. http://teradataforum.com/teradata/20121106_093640.htm Unused  stats maybe ...
121602 Jan 2015 @ 12:23 PSTGeneralReplyStored Procedure in TeradataTechnology should  serve business, in the best possible way. Stored proc objects are made for reasons, example-- In stored procedure, if we can stuff all business logic(s) in one pass, w...
121531 Dec 2014 @ 11:59 PSTDatabaseReplyFind Second Highest Salary - SQLcan you try something like this? select id,name,sal,dept from  (select  id,name,sal,dept,row_number()over(partition by dept,sal order by dept,sal desc) rn from your_table) abc...
121431 Dec 2014 @ 04:44 PSTGeneralReplyLoading data from Netezza table to Teradata table using TPTBTW Dieter, the odbc should be from Progress Direct if it is pre 15.0, am I right? Hoping the performance is good there.
121331 Dec 2014 @ 04:18 PSTGeneralReplyStored Procedure in TeradataI like Dieter's advocacy for macro in Teradata. In stored procedure, if we can stuff all business logic(s) in one pass, without logging in or off many times, it is advantageous. Cursor-based &n...
121230 Dec 2014 @ 10:57 PSTGeneralReplyLoading data from Netezza table to Teradata table using TPTThe last wizard I saw, Netezza was not there as source type.You can check it. Nevertheless, I used SAP DS, Ab Initio, Informatica... and there are other tools too to migrate. But it is better to c...
121129 Dec 2014 @ 10:04 PSTDatabaseReplyWhere summary stats are storedFrom the doc:  http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1142_111A/ch02.124.098.html   Summary statistics are recorded in the histogram h...
121029 Dec 2014 @ 08:37 PSTToolsReplyTeradata SQL GrammarWill the syntactical diagram from the document help you?
120929 Dec 2014 @ 08:35 PSTToolsReplyWrite Hierarchial file using Fast exportTo be more clear, maybe you can provide an example, because it may be misleading. I feel a combination of fastexport with unix scripting may help here. The word hierarchical, looks like you have ...
120828 Dec 2014 @ 11:04 PSTDatabaseReplyWhere summary stats are storedNot pretty sure of the question. You can refer to this wonderful blog of Dieter: http://developer.teradata.com/blog/dnoeth/2013/08/new-statsinfo-query-for-td14 After obtaining the details of summ...
120728 Dec 2014 @ 05:27 PSTDatabaseReplyGTT vs VTThis link can help you perchance: http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/Database_Management/B035_1093_111A/ch02.021.17.html#ww600825
120626 Dec 2014 @ 08:19 PSTDatabaseReplyBTEQ Command to execute sqls only to generate explain planDo you have Visual Explain? Another way, not so nice, is write a unix script, where you can store your sqls in control file with pointers and comments #. Call a script for that sql you want as par...
120526 Dec 2014 @ 01:28 PSTConnectivityReplyTeradata CONNECTION TABLE AUDIT A RSA ENVISIONI am not pretty sure of the question &  the setup of ENVISION RSA . What I know about RSA is logging, alerting, reporting ,analysis, incident management.... I think it is related to networ...
120425 Dec 2014 @ 09:55 PSTGeneralReplyFastLoad errorYou can check your input file , like data type, EOF.... Try to put  few rows and see if it works.
120321 Dec 2014 @ 08:32 PSTGeneralReplyData Quality checks on the user dataIf is is for a small and one-off situation , you can develop scripts. Teradata has Miner's Profiler, DQRM, if you have them. You can check. But many advanced features are also available in Atac...
120218 Dec 2014 @ 09:32 PSTGeneralReplyRunning Teradata Script in UnixI m not sure about your question. Since it is NZSQL for you and you made it TDSQL I think. The above script is just an example I highlighted. There are other ways too. We can do in interactive and ...
120118 Dec 2014 @ 08:24 PSTDatabaseReplyView TPT LogYou can check the permission: rwx..... by looking say for your userid: ls -ltr /opt/teradata/client/14.10/tbuild/logs ......or previous directory Try changing the permission: chmod from the ...
120018 Dec 2014 @ 08:14 PSTGeneralReplyRunning Teradata Script in UnixExample of bteq script from the documentation: #!/bin/sh ######################################### bteq <<EOI export DATADIR=/datasvc/data .LOGON mydbs/myid,mypw; .EXP...
119917 Dec 2014 @ 07:31 PSTToolsReplyTERADATA PROFILER QUERIESI remember vaguely how I resolved once the issue, when I tweaked a query, 2 years back. I do not know if TD Profiler has changed , the look and feel since then. I think in INPUT, OUTPUT, RESULTS......
119815 Dec 2014 @ 05:45 PSTGeneralReplyAvailability of tool to convert SQL queries to Teradata queriesMy Suggestion: Until and unless the tool(s) is/are thoroughly tested end to end, I better don't take any chance. I think it is better to understand the functionality and write the code in Terad...
119715 Dec 2014 @ 02:51 PSTGeneralReplyHelp in writing SQLWhich TD version??? It looks like udfconcat is left for me :)....kidding   In the below query, you can use regexp_replace  to replace (")  by ' ' and comma (,) by - ...

Pages