# | Date | Forum | Type | Thread | Post |
10 | 16 Nov 2011 @ 05:08 PST | UDA | Topic | hi i want to know now many hostnodes and hotstandby nodes in my environment is their any query to now from sql assistent |
hi i want to know now many hostnodes and hotstandby nodes in my environment is their any query to now from sql assistent
please infrom me
|
9 | 16 Nov 2011 @ 05:06 PST | UDA | Reply | find out the number of nodes in a teradata architecture |
hi i want to know now many hostnodes and hotstandby nodes in my environment is their any query to now from sql assistent
please infrom me
|
8 | 05 Aug 2011 @ 08:29 PDT | Tools | Reply | Numeric overflow | when we are running below query
SELECT
sd.fpd,
scr.pgi,fsh.cust_type_id,fsh.chnl_id,fsh .sub_sgmnt_cd,
sd.drvr_grp_fincl_id,
SUM(sd.wghtd_orgnl_val) (DECIMAL(18,6)) AS drvr_val,
COUNT(sd.srv_... |
7 | 01 Aug 2011 @ 07:33 PDT | Tools | Reply | Performance Tuning | i have question here related to performance issue,
when we do a joins iam geting a error as skew issue
may i know why iam getng this error
n how to resolve this issue ,
if i find a collect sta... |
6 | 28 Dec 2010 @ 06:29 PST | Training | Reply | Want Teradata SQL Tutorial | hi all,
i am teradata DBA,
i am new to teradata this technology,
can any one guide me
what certifications i have to do,
if any one have material please send to my email id
nareshgoud511@gmail... |
5 | 28 Dec 2010 @ 06:21 PST | Database | Reply | show view this is showing some what diffent | ya but it is not ARC COPY? |
4 | 21 Dec 2010 @ 07:10 PST | Database | Reply | show view this is showing some what diffent | hi WAQ
their difference in database name
in show iam giving ODS_OHR_REP_SOURCE_RECV*
--------
but in output it is showing... |
3 | 21 Dec 2010 @ 07:03 PST | Database | Reply | DBA query | grant create database,drop database on sysdba to username; |
2 | 13 Dec 2010 @ 01:08 PST | Database | Reply | show view this is showing some what diffent | show view ODS_OHR_REP_SOURCE_RECV*
it is showing
REPLACE VIEW ODS_OHR_REP_SOURCE*
may i know why is it showing like this |
1 | 13 Dec 2010 @ 01:06 PST | Database | Topic | show view this is showing some what diffent | show view ODS_OHR_REP_SOURCE_RECV.HR_PRT_PERSN_EDHR_D_V;
*** Text of DDL statement returned.
*** Total elapsed time was 1 second.
--------------------------------------------------------... |
|
|