#DateForumTypeThreadPost
1016 Nov 2011 @ 05:08 PSTUDATopichi 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  
916 Nov 2011 @ 05:06 PSTUDAReplyfind 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
805 Aug 2011 @ 08:29 PDTToolsReplyNumeric overflowwhen 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_...
701 Aug 2011 @ 07:33 PDTToolsReplyPerformance Tuningi 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...
628 Dec 2010 @ 06:29 PSTTrainingReplyWant Teradata SQL Tutorialhi 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...
528 Dec 2010 @ 06:21 PSTDatabaseReplyshow view this is showing some what diffentya but it is not ARC COPY?
421 Dec 2010 @ 07:10 PSTDatabaseReplyshow view this is showing some what diffenthi WAQ their difference in database name in show iam giving ODS_OHR_REP_SOURCE_RECV* -------- but in output it is showing...
321 Dec 2010 @ 07:03 PSTDatabaseReplyDBA querygrant create database,drop database on sysdba to username;
213 Dec 2010 @ 01:08 PSTDatabaseReplyshow view this is showing some what diffentshow view ODS_OHR_REP_SOURCE_RECV* it is showing REPLACE VIEW ODS_OHR_REP_SOURCE* may i know why is it showing like this
113 Dec 2010 @ 01:06 PSTDatabaseTopicshow view this is showing some what diffentshow view ODS_OHR_REP_SOURCE_RECV.HR_PRT_PERSN_EDHR_D_V; *** Text of DDL statement returned. *** Total elapsed time was 1 second. --------------------------------------------------------...