22 | 01 Feb 2016 @ 09:17 PST | General | Topic | Teradata 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... |
21 | 14 Jun 2012 @ 11:42 PDT | General | Topic | BackUp 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... |
20 | 21 Mar 2012 @ 07:08 PDT | General | Topic | Unassigned 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... |
19 | 17 Dec 2010 @ 02:31 PST | General | Reply | No more spool error- sel * from table sql | Spool 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... |
18 | 10 Nov 2010 @ 12:27 PST | Database | Topic | Increasing Datablock size in DBS | Hi 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... |
17 | 27 Oct 2010 @ 10:38 PDT | Database | Reply | How 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) || '... |
16 | 26 Oct 2010 @ 01:18 PDT | Database | Reply | how 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... |
15 | 18 Oct 2010 @ 02:39 PDT | Database | Reply | Index Suggestion vs Unnecessary Indexes | I 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... |
14 | 18 Oct 2010 @ 02:14 PDT | Database | Topic | Index Suggestion vs Unnecessary Indexes | Hello 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... |
13 | 11 Oct 2010 @ 02:28 PDT | Database | Topic | Auto code generation for data movement across environment : I/P required | Hi 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... |
12 | 07 May 2010 @ 10:51 PDT | Database | Reply | Evaluate SQL expr in column data | Can you plz post some sample data from both tables and expected o/p? |
11 | 07 May 2010 @ 10:42 PDT | Database | Reply | Temporary Tables in Teradata | Jawed,
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.
|
10 | 09 Apr 2010 @ 04:59 PDT | Database | Topic | input needed in sql design | Hello,
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... |
9 | 30 Mar 2010 @ 11:55 PDT | Database | Reply | Conditional (case statement) Join Criteria | Can you post some example for the same in which you facing issue.
|
8 | 30 Mar 2010 @ 11:42 PDT | Database | Reply | I'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. |
7 | 03 Sep 2009 @ 11:51 PDT | Database | Reply | Subqueries 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... |
6 | 03 Sep 2009 @ 11:42 PDT | Database | Reply | Stats collection frequency | For 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 ... |
5 | 05 Aug 2009 @ 10:01 PDT | Connectivity | Reply | SSO Integration through site minder or LDAP | Great.....
I will check this PDF and can you please check and let me know the further information.
Effort is appreciated....
|
4 | 05 Aug 2009 @ 10:00 PDT | Connectivity | Reply | SSO Integration through site minder or LDAP | Great.....
I will check this PDF and can you please check and let me know the further information.
Effort is appreciated....
|
3 | 04 Aug 2009 @ 04:18 PDT | Connectivity | Reply | SSO Integration through site minder or LDAP | Or can provide me the link or any URL for the same........ |
2 | 04 Aug 2009 @ 04:16 PDT | Connectivity | Topic | SSO Integration through site minder or LDAP | In 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... |
1 | 03 Aug 2009 @ 02:46 PDT | Database | Reply | Some 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)))-... |