#DateForumTypeThreadPost
1715 Aug 2012 @ 08:38 PDTToolsTopicSQL_SELECTOR: TPT15105: Error 13 in finalizing the table schema definition I have a proble with TPT, and never pass through this error. Script: DEFINE JOB EXPORT_TABLE_TO_FILE ( DEFINE SCHEMA TABLE_SCHEMA ( COL_MSISDN VARCHAR(40) ); ...
1604 Aug 2009 @ 12:59 PDTDatabaseReplyThoughts on CPUBusy caclulations.thanks @Random_Thought that query help me a lot
1520 Jul 2009 @ 07:45 PDTToolsReplyWhat tool (SQL Assistant?) do I use to browse a Teradata database?btw, it work on eclipse 3.5
1420 Jul 2009 @ 07:40 PDTToolsReplyWhat tool (SQL Assistant?) do I use to browse a Teradata database?I think this is the right URL for getting started with eclipse plugin: http://developer.teradata.com/tools/articles/getting-started-with-teradata-plug-in-for-eclipse
1315 Jul 2009 @ 04:33 PDTToolsReplyPerformance Tuningcan some one point me the right URL for Teradata @ Your Service?so that i can download this Orange Book
1215 Jul 2009 @ 04:21 PDTToolsReplyImproving Loading Mechanism using FastloadHi dieter,actually, yesterday we found out that TPT is using MLOAD also.so, we postpone the development for TPT, instead we focus on finding the bottle neck.we found out that in our target table, w...
1113 Jul 2009 @ 11:00 PDTToolsReplyImproving Loading Mechanism using FastloadHi everyone,actually, i had already implement 10 parallel fastload to load these 40.000 files.with these configuration we managed to load 60.000 files per day.but,...with that kind of configuration...
1024 Nov 2008 @ 03:24 PSTDatabaseTopicSelect only when changing is occuredlet say we have data like the one below:item|product_code|trx_dateA|001|2008-10-10A|001|2008-10-11A|002|2008-10-12A|002|2008-10-13A|001|2008-10-14A|001|2008-10-15A|003|2008-10-16and we want to sele...
902 Nov 2008 @ 10:54 PSTDatabaseTopicUNIQUE PRIMARY INDEX ProblemsHi guys,as usual :)i have difficulty to understand the term of UPI.it said that it will guarantee the uniqueness of a table.but somehow, when i do merge into statement, it return error.the error sa...
823 Oct 2008 @ 11:08 PDTDatabaseTopicMERGE INTO IssueHi everyone,i have an issue regarding the MERGE INTO statement.Let say that i have this statement for example:explain MERGE INTO DB_A.TABLE_Ausing(SELECT Field_01 , Field_02 , Field_03 , count(*)...
722 Oct 2008 @ 05:30 PDTToolsReplyImproving Loading Mechanism using Fastloadthis is log if i run in single fastload (not parallel fastload)**** 11:53:59 Processing starting at: Wed Oct 22 11:53:58 2008**** 11:53:59 FDL4866 SESSIONS command accepted**** 11:53:59 Error limit...
622 Oct 2008 @ 12:49 PDTToolsReplyImproving Loading Mechanism using Fastloadokay.i think i know the problem isi set the wrong argument for SET SESSIONi useSESSION 4 8;it has to be SESSION 8 4;right now i can process 20 files per 5 minute.and set the session toSESSION 12 8...
521 Oct 2008 @ 10:26 PDTToolsReplyImproving Loading Mechanism using Fastloadplease find the attachment for fastload and inserting to stage table log.
421 Oct 2008 @ 10:20 PDTToolsReplyImproving Loading Mechanism using Fastloadis not that i don't care of how much each column length and type.it is because the content will vary and depend on the record profilelet say there are 3 types of record profile with:Type 1column 1:...
321 Oct 2008 @ 06:16 PDTToolsReplyImproving Loading Mechanism using Fastloadi am still using the previous mentioned scenario with some changes:1. Add Primary Index to fastload target table- i have put primary index in fastload target table using multiple column that use in...
215 Oct 2008 @ 11:01 PDTToolsReplyImproving Loading Mechanism using Fastloadsince the source file keep coming to landing point.---so, instead of increasing the session, wiser to increase number of fastload node.for that reason, i come out with this scenario.(1)FASTLOAD sce...
114 Oct 2008 @ 11:58 PDTToolsTopicImproving Loading Mechanism using FastloadHi all!I am new to Teradata and this is my first topic.first of all, i like to share my problem (perhaps a challenge for those who advance in Teradata :) ).Okay!i have to load a lot of file from A ...