#DateForumTypeThreadPost
1102 Jan 2012 @ 09:58 PSTGeneralReplyBTEQ error handling In Bteq, To prevent Known & Unknown error at RUNTIME we use user-defined actions called Error handling.  we do error handling by using ERROR LEVEL  Error level means - &nbs...
1030 Dec 2011 @ 11:06 PSTDatabaseReplyDIff b/w Hash join and Product join Basing on situation, Optimizer select the join.. If it is small table product join is ok comparitvely than hash join.. So we need to take explian plan for both produc join and hash join .. Watch...
930 Dec 2011 @ 10:59 PSTDatabaseReplyDIff b/w Hash join and Product join Hi, Product join : It is a cross product of two tables (nothing but a cross join). Generally ,it occurs                     Using &...
829 Dec 2011 @ 10:31 PSTDatabaseReplyCollecting Statistics on multiple Columns Hi,     Can anybody explain, when the collect stats on multi-columns is use??
727 Dec 2011 @ 08:39 PSTDatabaseReplyAMP can have 1 and only 1 VDisk but can have many Physical Disk As per my knowledge, there is common virtual disk.so each Amp is responsible to manage one portion of space (vdisk) leads to shared nothing architecture   So when can we say Shared ...
619 Jul 2011 @ 08:12 PDTTrainingReplyTeradata 12 CertificationI want to give attempt for TD12 certification.if anybody completed TD12 certification,please forward the any TD12 certificate dumps or material...
519 Jul 2011 @ 10:57 PDTDatabaseReplyGlobal temporary tablesThanks a lot
414 Jun 2011 @ 09:19 PDTGeneralReplyVolatile tables1.) We can create PI 2.) We can create SI 3.)We can capture Stats,if it is TD13 0r above for Volatile tables
314 Jun 2011 @ 08:49 PDTGeneralReplyMULTILOAD CONSTRAINTSAs per knowledge am sharing, Actually Mload works on NUSI because it is a AMP local (sub-table machenism)Operation.There is no need to dependent on Other Amps. Note : No use of USI,JI,RI
224 May 2011 @ 09:34 PDTToolsReplyCAN I WRITE ERRORED RECORDS INTO A FILE IN MLOAD?By writing this command Format Vartext '|~,|' DISPLAY ERRORS NOSTOP, V can store all the errors records in a table ?? please give clear idea Thank you....
124 May 2011 @ 09:23 PDTToolsReplyhow to bypass bad record in MultiloadCould you people explain me NOSTOP option in MLOAD??