#DateForumTypeThreadPost
4029 Jun 2010 @ 04:16 PDTJobsReplyLooking for Teradata training & Scopehi , I am giving Teradata training , please mail me s.b.sheeba@gmail.com .
3929 Jun 2010 @ 04:14 PDTTrainingReplyAny best Training Centres you guys know in Hyderabad??hi , I am giving Teradata training , please mail me s.b.sheeba@gmail.com .
3829 Jun 2010 @ 04:11 PDTTrainingReplyTeradata Traininghi , I am giving Teradata training , please mail me s.b.sheeba@gmail.com .
3729 Jun 2010 @ 03:32 PDTTrainingReplyTeradata PPThi , I am giving Teradata training , please mail me s.b.sheeba@gmail.com .
3614 Sep 2009 @ 01:21 PDTTrainingTopicWANTED TERADATA TRANING -CHENNAIHI I AM GIVING TERADATA TRAINING, IF ANY BODY INTERESTED MAIL TO S.B.SHEEBA@GMAIL.COM
3510 Feb 2009 @ 06:28 PSTToolsReplyHow to auto generate tpump/fast load scriptusing datastage etl tool u can automatically generate the scripts.
3410 Feb 2009 @ 05:45 PSTToolsReplyAmbiguous results by fastexport..U CAN USE AS (CHAR) DTATYPE... AND GIVE CORRECT LENGTH OF THE FIELD..FOR EXAMPLE DEC(11,0)-SHOULD BE CHAR13 DEC(13,0) -CHAR15 SMALL INT -CHAR6 ...
3305 Feb 2009 @ 06:38 PSTToolsReplyProblem with Multiload AcceptEXPORT REPORT DDNAME DELDATE sel end_date (title '') from tableA;.EXPORT RESET try like thisEXPORT REPORT DDNAME DELDATE sel end_date (title '') (FORMAT 'YYYY-MM-DD') (CHAR(10)) from tableA;.EXPORT...
3219 Jan 2009 @ 08:22 PSTToolsReplyLoading multiple tables with Fastload only logging in onceUSING FASTLOAD U CAN LOAD 1 TABLE AT A TIME WITH MULTIPLE INPUTFILE.
3119 Jan 2009 @ 08:15 PSTToolsReplyHow to return BTEQ and Fastload error codes to Unixbteq << EOF .logon $SERV/$USER,$PASS database $DBN; .RUN FILE=$SDIR/A.txt; .logoff .quitEOF#****** Check for Return code ********# if [[ $rc != 0 ]] then exit $rc fi
3012 Sep 2008 @ 12:49 PDTToolsReplyEXEC BTEQTHX
2909 Sep 2008 @ 08:12 PDTToolsTopicEXEC BTEQHOW 2 EXECUTE BTEQ SCRIPT IN COMMAND LINEEX:SCRIPT IS LOCATED IN D:\A.TXT
2804 Sep 2008 @ 08:36 PDTToolsTopicCOLLECT STATISTICSHI WHAT IS THE USE OF COLLECTING STATISTICS AND EXPLAIN CPMMAND? HOW 2 FIND OUT THE LEVEL IT IS HIGH OR LOW????
2728 Aug 2008 @ 08:49 PDTDatabaseReplyskew factorthx how 2 find out skew value?
2627 Aug 2008 @ 07:53 PDTDatabaseTopicskew factorhi what is skew factor????? what is the use of that?
2514 Aug 2008 @ 08:15 PDTToolsReplyIssues in Multiloadin mload create table as MULTISET table... then it will allow duplicate value to the table....TABLEcreate multiset table job_grades(gra varchar(20),lowest_sal integer,highest_sal integer) pri...
2413 Aug 2008 @ 08:26 PDTToolsReplyIssues in MultiloadHI whether u wnat to load duplicate record in the mload table.
2312 Aug 2008 @ 11:26 PDTDatabaseReplyskew factorplease give me idea about skew factor with examplethx
2212 Aug 2008 @ 11:13 PDTToolsReplyHow to import data from excel sheet using SqlAssistantJunior Member Group: Forum Members Last Login: Today @ 9:41:19 PM Posts: 22, Visits: 65 hi-------------------I) Approach I------------- 1. Export data File from Excel to Comma Separated values (C...
2111 Aug 2008 @ 06:29 PDTToolsReplyFastload: Incorrect number of bytes returned from a File ReadHI ERRR IN THE DEFINE STATEMENT.
2011 Aug 2008 @ 05:30 PDTToolsReplyhow to avaoid Junk values in Fast Exportthis is the exampleSELECT CAST(a_MODNUM_R AS CHAR(11)) (title '') ,CAST(a_VERNUM_R AS CHAR(11)) (title '') ,a_MODEL_TP_C (CHAR(1)) (title '') ,a_SCRTYP_C (CHAR(1))...
1911 Aug 2008 @ 05:24 PDTToolsReplyhow to find sysdate and time valuethanks
1811 Aug 2008 @ 05:13 PDTToolsReplyFlat file with delimiters in FastExportGIVE each column datatype and length ok
1705 Aug 2008 @ 05:22 PDTToolsTopichow to find sysdate and time valuehow 2 find out sysdate and systime in teradatain oracle v used to give select sysdate from dual;like thatwhat is the coomand for teradata?
1605 Aug 2008 @ 04:52 PDTToolsReplyhow to avaoid Junk values in Fast Exportgiving correct datatype and size of each column.v can avoid the junk values

Pages