#DateForumTypeThreadPost
107110 Oct 2014 @ 10:18 PDTDatabaseReplySeparation of columns into rowsselect id,inst,package,(character_length(demog) -character_length(regexp_replace(demog,'[^A-Z 0-9]+','',1,0,'i))+1) m,regexp_substr(demog,'[^;]+',1,day_of_calendar) from...
107009 Oct 2014 @ 10:11 PDTGeneralReplyWhen trying to insreat into log table getting deadlock on TPT scriptUsually deadlock occurs due to retry like in bteq. You could have placed your post under  TOOLS  and you can get better response :)
106909 Oct 2014 @ 09:33 PDTDatabaseReplyRow level Duplicate Record eliminationYou have not shared much detail :). sample data..... what you have and what you want as output. You can think of  qualify row_number() over(partition by mmm, nnnn order by mmm, nnnn asc....
106809 Oct 2014 @ 09:12 PDTGeneralReplyusing a calculation done in the previous row in this row's calculationI m not Dieter :). you can do something like this: select year1,month1,week1,count1, (count1-coalesce(max(count1)over(order by count1 rows between  1 preceding and 1 preceding),0) m from you...
106709 Oct 2014 @ 08:10 PDTDatabaseReplyImport data from excel in a stored procedure / macroIf I understand it correctly, you want to read an excel file in a stored proc or macro. and do something.... and deliver to ssrs...... I am also thinking from a standpoint of Teradata -excel OLAP ...
106609 Oct 2014 @ 08:24 PDTTrainingReplyAny institute for training in BangaloreBangalore is so big, commuting from one area to another takes hours, even with less traffic :). Which training you want? face-to-face, virtual. I feel that training in India should take a new shap...
106509 Oct 2014 @ 02:28 PDTTeradata ApplicationsReplyJobs failing after upgrading Teradata Client from 13.0 to 13.1 in AbinitioIt is my initial thought. It can be  because of the settings in ab initio dbc file. Did you test your ABINITIO dbc (not teradata dbc), say m_db test abcdefghi.dbc against 13.10 or the selec...
106409 Oct 2014 @ 12:51 PDTDatabaseReplymatch against next rowMaybe you can show your sample data? what you have and what you expect. Right now  can think of putting something like this, just the logic(min/max) or it can be rows between 1 following...
106308 Oct 2014 @ 09:36 PDTDatabaseReplyHow to avoid using QUALIFY OVER PARTITION BYYou can think of group by   and having. I see that  you do a left join on the same table many times on constant fields. I am not aware of your "WHERE" clauses. Just my thought ...
106208 Oct 2014 @ 09:19 PDTDatabaseReplysimplest way to search substring and set flagYou can think of this way: select id,list,case when substr(list,1,3)='000' or substr(list,5,3)='000' or substr(list,9,3)='000' then 1 else 0 end flg1, case w...
106108 Oct 2014 @ 08:59 PDTDatabaseReplyRunning Operating System Command from a Stored ProcedureMy suggestion: I think it is better to keep it clean. Run and compile the logic in bteq and bteq in Linux/unix script. In this way, the design is clear, easy to maintain and logical.  In Lin...
106008 Oct 2014 @ 12:06 PDTDatabaseReplysimplest way to search substring and set flagtry with  select id,list,case when regexp_similar(list,'[^000]+$','i')=0 then 1 else 0 end flag1 fro your_table and let us see.
105908 Oct 2014 @ 08:39 PDTDatabaseReplyTimestamp for the previous dayselect myTimeValue -interval '1' day from your_table;
105808 Oct 2014 @ 07:05 PDTDatabaseReplyFind user id You can query DBQL tables like dbqlogtbl,dbqlsqltbl , dbc.accesslog... dbc.qrylog
105708 Oct 2014 @ 01:11 PDTDatabaseReplyInformation about single table join index and NUSI and USI A column subset of a very large base table defined with a NUPI defined on a join key that causes its rows to be hashed to the same AMP as another very large table with a primary index defined on...
105607 Oct 2014 @ 11:48 PDTDatabaseReplyNeed help in Optimizing Row_Number/RANK() operationsWhat is the logic, that you arrive at valid_to  from the output of ist row , 2nd row, 3rd row, 4th row?
105507 Oct 2014 @ 08:52 PDTToolsReplyWhich utilities to choose when compared to TPTTPTs have more functionalities and they are latest. Fload, mload ... are legacies. you can refer to few discussions: https://forums.teradata.com/forum/tools/looking-for-comparison-of-teradata-pt-...
105407 Oct 2014 @ 07:11 PDTDatabaseReplyNeed help in Optimizing Row_Number/RANK() operationsYou can try something like this: select .....,your_field, max(your_field) over (order by your_field rows between 1 preceding and 1 preceding) m qualify m<your_field----- <for test> ...
105307 Oct 2014 @ 06:25 PDTDatabaseReplyView with a dynamic table in FROM clause (without using Java or C)?As far as I know , it cannot be done, query band test and then do a select..... :) Let us hear from other who may have done this. In sql udf, only simple test we can do ....I think.
105207 Oct 2014 @ 03:39 PDTGeneralReplyHIGH - SesAmpCpuFew things that come to mey mind: You can check if there is any product join. Check if you can avoid redistribution, avoiding IO and CPU. If can use column-partitioning, also there is a chance ...
105106 Oct 2014 @ 11:32 PDTDatabaseReplyterdata sql optimisation (tuning)Factors can be size of tables, wrong choice of PIs, joins , stale stats etc etc. Teradata is so rich in terms of tools.  You can have a look at  explain or tools like TD index wizard, TV...
105006 Oct 2014 @ 11:07 PDTDatabaseReplyOracle vs Teradata ParallelismTeradata's execution is parallel in terms of joins,aggregation,sorts..... How about other DBs?  Oracle: The optimizer first calculates a serial execution plan for the SQL statement; if th...
104906 Oct 2014 @ 04:25 PDTDatabaseReplyDBC VIEWs trim to length 30 on Teradata 14I think this discussion can help you: http://forums.teradata.com/forum/database/dbc-tables-has-truncated-view-defination-in-requesttext-field-how-can-i-find-full#comment-136660   When you d...
104806 Oct 2014 @ 02:06 PDTDatabaseReplyMulti-Value compression has increased the table sizeYou can read the doc :) You cannot compress more than 255 distinct values for an individual column.   There are few more guidelines too.
104705 Oct 2014 @ 11:14 PDTConnectivityReplySAP Business Objects 4.1 SP2 connecting to Teradata 14I think this error is due to ODBC set up. Most of the machines these days are 64 bit  OS, rather than 32 bit. The execution of c:windows ..... \SysWoW64\odbcad32.exe and \System32\od...

Pages