#DateForumTypeThreadPost
1223 Nov 2008 @ 12:42 PSTAnalyticsTopicCheckpoint restart using log tableHi,Does MLOAD allows checkpoint restart , if the input PS files in MLOAD step are concatenated files? Also will there be any performance improvement if we concatenate the i/p files in previous step...
1124 Oct 2008 @ 11:34 PDTAnalyticsReplyReducing runtime for a MLOAD jobWe are loading in to an empty table and this is a refresh load.
1023 Oct 2008 @ 03:22 PDTAnalyticsReplyReducing runtime for a MLOAD jobNo records are going to UV table. Also it is using UPI.
914 Oct 2008 @ 09:45 PDTAnalyticsTopicAMPCHECKHi,If I change AMPCHECK= ALL to AMPCHECK =NONE in a mload job, Will it impact the performance ?Thanks
814 Oct 2008 @ 09:43 PDTAnalyticsReplyReducing runtime for a MLOAD job26 millions of records are in the file and not in the target table.
713 Oct 2008 @ 01:24 PDTAnalyticsReplyReducing runtime for a MLOAD jobHi,I have noticed that the options AMPCHECK IS ALL and also 40 input files are concatenated. CHKPOINT is default 15mts. Table is not a fall back. Will this affect performance?
612 Oct 2008 @ 12:59 PDTAnalyticsReplyReducing runtime for a MLOAD jobHi,Please find the details belowWhat is the number of records on the table ? is it partitioned ? on what ? how many records per partiton ? do you load across partitions ?Is your table set/multiset ...
510 Oct 2008 @ 10:57 PDTAnalyticsTopicReducing runtime for a MLOAD jobHi All,I have a monthly MLOAD job which loads around 26 millions of records, but it takes 16 - 20 hours to complete loading. Can someone give some tips to improve performance and reduce runtime? PS...
407 Oct 2008 @ 12:30 PDTAnalyticsTopicTo find record counts for all tables in a particular databaseHi,Can someone help me to write a query to pull Record counts for all tables in a particular database or record counts for all tables present in Teradata.Thanks a lot
320 May 2008 @ 03:10 PDTToolsTopicSystem variables in BTEQ like MLOADHi, Do we have any system specified variable for BTEQ utility like &SYSRCDCNT1, &SYSRJCTCNT1,&SYSINSCNT1, &SYSUPDCNT1, &SYSDELCNT1, &SYSUVCNT1, &SYSETCNT1 which we have have in MLOAD?
229 Jul 2007 @ 05:06 PDTToolsTopicVarchar in Fast ExportHi , when i use fast export utility for unloading records from a column having data type "varchar" i am getting two dots (Junk characters) infront of each record. I don't want to cast this fie...
101 Nov 2005 @ 09:43 PSTUDATopicData retrieval queryHi all,I want to retrieve last 3 months data from a table,in which datas are loading daily. I have a query but it is retrieving last 3months data + data loaded till current day.But I need only last...