#DateForumTypeThreadPost
1301 Feb 2010 @ 02:23 PSTToolsTopicRegarding Temporary SpaceHi FriendHelp me to solve the following questionWhich of the following is a statement that is true regarding temporary space? A. Temporary space is spool space currently not used. B. Temporary spac...
1201 Feb 2010 @ 02:19 PSTTrainingReplyTeradata 12 CertificationHi DevPlease help in TD12 CertificationIf you have any material please send me.Thanks and RegardsKIRAN
1129 Jan 2010 @ 02:19 PSTToolsTopicNUSI VS FULL TABLE SCANHi AllWhat is the difference between NUSI and full table scan?RegardsKIRAN
1015 Jan 2010 @ 02:04 PSTAnalyticsReplyTeradata Material for 4th, 5th and 6th V2R5 Certificationhi pooja,can u send me the teradata basics materialThanks kirankiran.kandem@gmail.com
915 Jan 2010 @ 01:57 PSTToolsReplyinserting data into one table from multiple tablesinsert into table1 values(firstname,phoneno,lastname)select fname,(select t2.phonenumber from table2 t2,table3 t3 where t2.firstname=t3.fname),lname from table 3;insert into table1 (fname, pno, lna...
830 Nov 2009 @ 07:25 PSTDatabaseTopicPrimary IndexeThere are three columns in a table col1, col2, col3.col1 is 100% unique data but data is never used col2 is 98% unique data used for where clausecol3 is 95% unique data used for join processingOn...
720 Oct 2009 @ 01:44 PDTToolsReplyImport in TD SQL AssistantCan We load only specific columns using SQL AssistanceIf so please send me the process.Thankskiran
619 Oct 2009 @ 01:48 PDTToolsReplyI am unable to load data using SQL AssistanceBut c the Help in tool bar and c the api, it says it support
518 Sep 2009 @ 05:07 PDTToolsReplyI am unable to load data using SQL Assistanceinsert into product (p_partkey, p_name, p_mfgr, p_brand,p_type,p_size, p_container, p_retailprice, p_comment) values(?,?,?,NULL,?,?,?,?,?);THEN THE O/P IS WRONG NO. OF DATA VALUES IS DISPLAYEDThe n...
414 Sep 2009 @ 01:09 PDTToolsTopicCan We use filler concept in FastLoadHi FriendsCan we load filler concept in fastload, i.e., i want to select only specified columns in the fastload, can i do the job?ThanksKIRAN KUMAR
314 Sep 2009 @ 01:05 PDTToolsReplyI am unable to load data using SQL AssistanceThanks for Your Help, I used only single quotes, not double qoutes, even the same problem
210 Sep 2009 @ 02:20 PDTToolsTopicI am loading the data into files using fastexport but...HiI am loading the data into files using fastexport but the data is in binary format eventhough i am using text format, please send me a sample script to load the data into tables in a text format....
110 Sep 2009 @ 02:06 PDTToolsTopicI am unable to load data using SQL AssistanceHi FriendsI am unable to load the data when inserting nulls or strings in the table using QUERY MAN.insert into fact_current values(id, name, ,"expected",salary);Wat is the problem?Please tell me t...