#DateForumTypeThreadPost
2107 Aug 2009 @ 03:19 PDTDatabaseReplyPPI codeThe complete ..one say... create set table tt(.....)PARTITION BY RANGE_(.....Here the codes.....till the end.....);
2007 Aug 2009 @ 02:31 PDTDatabaseTopicPPI codeHi,Can anyone please paste script of teradata PPI script here? Somehow I could not find it in my docs...Thanks in advance....Raja
1907 Aug 2009 @ 02:01 PDTUDAReplyMLoad ErrorPaul,1) Check how many instances are/were runniing when you run your mload.2) Which USER_ID YOU EXECUTE YOUR SCRIPT? :)Then you will get an answer.... :)Rgds,Raja
1831 Jul 2009 @ 01:37 PDTToolsReplyFlat files to Teradata tablesHi,Say for mload: 1)First you need to have your logtable declaration 2) Logon to database 3) You must have the target table in place or you need to create after login in 4) then you declare .begin...
1730 Jul 2009 @ 01:22 PDTUDAReplyDifficulty Inserting records into Large tableHi,Can you please share your master table ddl strcuture at least the defination part..You can mask your field definations ......Thanks and regards,Raja
1624 Jul 2009 @ 05:40 PDTToolsReplyTpump - RATE StatementHi Rock,Once you defined logtable,and logon etc, we desribe the parameters : .BEGIN LOADSessions 10 2pack 10robust on/offserialize on/offcheckpoint say 30nomonitorrate 2errortable Rock_err;.layout ...
1523 Jul 2009 @ 04:40 PDTUDATopicWhat are the advantages of Teradata over KickfireHi,I need to quickly understand the advantages of Teradata over Kickfire.Please let me know.I know Teradata well and all functionalities. But here I need your help.Regards,Raja
1422 Jul 2009 @ 03:12 PDTToolsReplyhow does fastload identify duplicates while loading ???Hi,Interesting question :) . For fast load the table must be empty.If we load multiset table in fastload the it throws the duplicated rows.It must not have SI. I am also interested to know.Rgds,Raja
1322 Jul 2009 @ 12:37 PDTToolsReplyhow to MLOAD byte dataHi,I am not pretty sure if I cant see the code.Can you please share only the sample code if I can have a look and what is the error thrown.Did you try with .IMPORT INFILE "yourinput file" FORMAT BI...
1222 Jul 2009 @ 12:24 PDTAnalyticsReplyWill MLOAD able to Insert data into Global Temporary Tables !!!Hi Chris,If it 's me then I will create a table in mload script itself. I will load into this from internal and external processes needed. Then the macro..... Then in the mload script itself I will...
1120 Jul 2009 @ 03:56 PDTToolsTopicClarificationsHi,Can someone explain to me this code: .SET DBASE_TARGETTABLE TO 'fexp_usr'; /*This I underwstand */.SET TARGETTABLE TO i999839999;/*This I underwstand */.BEGIN IMPORT MLOAD /*This I underwstand *...
1020 Jul 2009 @ 01:44 PDTUDAReplyMigrating data from teradata to OracleHi,I m thinking this way:.LOGTABLE fexp_logtab;.LOGON 127.0.0.1/tduser,tduser;DATABASE dbc;.BEGIN EXPORT SESSIONS 20;.EXPORT OUTFILE 'your path' FORMAT TEXT;SELECT (CASE WHEN location_key IS NULL ...
917 Jul 2009 @ 04:13 PDTAnalyticsReplyWill MLOAD able to Insert data into Global Temporary Tables !!!Hi,We can insert using mload,tpump,fastload,bteq. Insert/update/delete we can use mload,bteq,tpump.I wonder why you need to load to GTT as it gets discarded at the end of session. Anyway I m not pr...
817 Jul 2009 @ 02:10 PDTDatabaseReplyUseful system viewsRestrict it using Tablekind='V' and you can restrict it using databasename=(Whatever you want say DBC etc etc..Rgds,Raja
716 Jul 2009 @ 07:04 PDTDatabaseReplyStrange ProblemHi,I think we can use BT ......ET also...right if we are using teradata mode.?Rgds,Raja
616 Jul 2009 @ 06:06 PDTToolsReplyUsing Parameter in BTEQHi,I m not sure in BTEQ. iT WORKS FINE IN MLOAD,FASTLOAD,TPUMP. It works this way:(ASSIGN THE DATE TO A VARIABLE and use that variable).Let me know if it works. I m not able to test it..SET DD TO '...
516 Jul 2009 @ 02:50 PDTUDAReplyTeraData vs OracleOracle and Teradata have their own unique distinct features. I have worked on both and certified in both.Being in datawarehousing,I feel the partition part Oracle is far ahead. Materialzed view ora...
416 Jul 2009 @ 02:05 PDTDatabaseReplyQuery hangsYou have not mentioned whether you are using bteq,mload,fastload, so that we can check the error log tables,restart log table.
316 Jul 2009 @ 01:04 PDTToolsTopicFASTLOAD1) Why there is no journalling or fallback in Fastload?2) In fastload, I cannot have USI or NUSI right? I know I can drop them and recreate after loading. But can anyone explain clearlywhy I cannot...
215 Jul 2009 @ 08:11 PDTToolsReplySQL assistant vs BTEQMost of the work I do is in unix platform(bteq,mload,tpump,fastload). In bteq we can conveniently put our programmingin unix environment and it looks good. In windows platform I dont appreciate it ...

Pages