#DateForumTypeThreadPost
2201 Feb 2016 @ 09:17 PSTGeneralTopicTeradata Front End Web Application ? All,   I am exploring the opportunities to have front end web based application on Teradata Enterprise Data Warehouse.   Intend of this application is to pilot automati...
2114 Jun 2012 @ 11:42 PDTGeneralTopicBackUp Identification Process. Fellows, I am working on a process to identfy backups within environment. And in order to answer this I designed a query below query but this only answers that what all tables within hav...
2021 Mar 2012 @ 07:08 PDTGeneralTopicUnassigned Work Load Definition For properly Configured User in TASM !!!!   In our shop we have Teradata with DBQL & TASM implementation.   Yesterday I extracted some data from DBQL for analysis that consists queries performance metrics along...
1917 Dec 2010 @ 02:31 PSTGeneralReplyNo more spool error- sel * from table sqlSpool space error can come due to multiple reasons. Are u putting and condition in query ? Also what is the skew factor for this table? Also check with admin for the spool space allocated to...
1810 Nov 2010 @ 12:27 PSTDatabaseTopicIncreasing Datablock size in DBSHi All, In DBS control if I will increase the size of data block then IO operation will reduce up to certain extent. But I am curious to know the impact on CPU utilization for changing data blo...
1727 Oct 2010 @ 10:38 PDTDatabaseReplyHow to get the create script of procedure or macro without knowledge about object type?SELECT TABLEKIND, CASE WHEN TABLEKIND = 'P' THEN 'SHOW PROCEDURE ' || TRIM(DATABASENAME) || '.' || TRIM(TABLENAME) || ';' WHEN TABLEKIND = 'M' THEN 'SHOW MACRO ' || TRIM(DATABASENAME) || '...
1626 Oct 2010 @ 01:18 PDTDatabaseReplyhow to abort session without PEMON or TDManager ?Syntax to execute abortsession. REPLACE FUNCTION AbortSessions (HostIdIn SMALLINT, UserNameIn VARCHAR(30), SessionNoIn INTEGER, LogoffSessions VARCHAR(1), UserOverride VARCHAR(1) ) SELE...
1518 Oct 2010 @ 02:39 PDTDatabaseReplyIndex Suggestion vs Unnecessary IndexesI did typo in second entry it will be like this. DATE DBNAME TABLENAME COLNAME JOIN_CONDITION Weight DELFLAG 10/18/2010 DB1 TAB1 COL1 TAB1.COL1=TAB2.COL1 1 Y 10/19/2010 DB1 TAB1 COL...
1418 Oct 2010 @ 02:14 PDTDatabaseTopicIndex Suggestion vs Unnecessary IndexesHello All, I am working on a implementation which let us know about utilization of indexes in real time use. This implementation has two parts. 1) Identifying all those columns which is bei...
1311 Oct 2010 @ 02:28 PDTDatabaseTopicAuto code generation for data movement across environment : I/P requiredHi All, I know that for moving data from one environment to another environment of Teradata there is lot of methods like bteqs, nparc, arcmain etc. But other then these I am working on intere...
1207 May 2010 @ 10:51 PDTDatabaseReplyEvaluate SQL expr in column dataCan you plz post some sample data from both tables and expected o/p?
1107 May 2010 @ 10:42 PDTDatabaseReplyTemporary Tables in TeradataJawed, For storing data GT is dependent on temp space. But DDL of GT or any other table consumes permanent space. so as carlos said you need to have adequate amount of permanent space.
1009 Apr 2010 @ 04:59 PDTDatabaseTopicinput needed in sql designHello, I am trying to manipulate below source data a particular o/p using OLAP functions. Below data is there is one of the staging table. And need to populate another fact table from this d...
930 Mar 2010 @ 11:55 PDTDatabaseReplyConditional (case statement) Join CriteriaCan you post some example for the same in which you facing issue.
830 Mar 2010 @ 11:42 PDTDatabaseReplyI'm a learner of teradata. And could you advise me How to study teradata?Best way is to install TD express (for 32 bit OS) on your PC or Vmware for 64 bit OS. And then next next.... And once u done with install it has some schema in there. So you can start from there.
703 Sep 2009 @ 11:51 PDTDatabaseReplySubqueries Workaround Select patient_name Patient_age, Patient_weight P.CountWarfarin, P.CountHeprin from patient left join (select patient_id,sum(case when drug_name = 'Warfarin' then 1 else 0 end) CountWarfar...
603 Sep 2009 @ 11:42 PDTDatabaseReplyStats collection frequencyFor stats collection we cannot define ideal frequency because it depends on data changes. When data changes in table is more then 10% then it is advisble to collect stats. you can write a bteq ...
505 Aug 2009 @ 10:01 PDTConnectivityReplySSO Integration through site minder or LDAPGreat..... I will check this PDF and can you please check and let me know the further information. Effort is appreciated....
405 Aug 2009 @ 10:00 PDTConnectivityReplySSO Integration through site minder or LDAPGreat..... I will check this PDF and can you please check and let me know the further information. Effort is appreciated....
304 Aug 2009 @ 04:18 PDTConnectivityReplySSO Integration through site minder or LDAPOr can provide me the link or any URL for the same........
204 Aug 2009 @ 04:16 PDTConnectivityTopicSSO Integration through site minder or LDAPIn our project setup BO uses hard coded user id and password to fetch the data from teradata. So for each user the generic ID is there in DBQL. Now we want to integrate the SSO authentication e...
103 Aug 2009 @ 02:46 PDTDatabaseReplySome SQL help sel Z.a,Z.b,Z.c from( select position(',' in 'ans1,ans2,ans3') pos1 ,substr('ans1,ans2,ans3',1,(pos1-1)) a ,substr('ans1,ans2,ans3',(pos1+1),position(',' in substr('ans1,ans2,ans3',(pos1+1)))-...