#DateForumTypeThreadPost
3807 May 2015 @ 02:11 PDTToolsReplyFASTEXPORT with MLSCRIPT optionHi, I only need the FEXP job output and the corresponding FEXP-generated MLOAD job output. These files should not be as large as 1.6TB. The huge data file is not needed. At least, please share wi...
3716 Apr 2015 @ 07:57 PDTToolsReplyFASTEXPORT with MLSCRIPT optionHi, Can you send us the FEXP job output and the corresponding FEXP-generated MLOAD job output? Thanks!
3605 Jan 2015 @ 03:25 PSTToolsReplyMLOAD and loading of: Empty Strings and Null StringsHi TDDeveloper, Can you share with me your MultiLoad script and the target table definition? Thanks! --Ivy.
3518 Dec 2014 @ 09:35 PSTToolsReplyMLOAD and loading of: Empty Strings and Null StringsHi, I tried a MultiLoad script, MultiLoad can load blank space charcaters and NULLs respectively. Here is the MultiLoad script: .LOGTABLE logt_a; .LOGON <tdpid>/<userid>, <passwo...
3416 Dec 2014 @ 01:03 PSTToolsReplyMload utility is loading unexpected data into table You can try the following layout: .FIELD EmpNo * char(4); .FIELD DeptNo * char(4); .FIELD Salary * char(3); for this specific data file. BTW, text format requires all CHAR or ANSIDATE data ...
3306 Nov 2014 @ 02:29 PSTToolsReplymload with NOSTOP option ends with Return Code 4Hi, The return code handling for this case is different between MultiLoad and TPump. MultiLoad sets the return code to 4 due to the rejected rows, while TPump does not. Thanks! --Ivy.
3204 Nov 2014 @ 02:10 PSTToolsReplyMload Performance IssueComparing with the old output, this part looks suspicious: **** 09:38:23 UTY0827 A checkpoint has been taken, recording that input record      10000 has been processed for IM...
3111 Sep 2014 @ 09:44 PDTToolsReplyMultiload ErrorWhich Teradata Data Connector version are you using? Please use the latest version of Teradata Dataconnector and re-run the job. Thanks! --Ivy.
3010 Jun 2014 @ 05:14 PDTToolsReplySIGTREM error during MLOADHi KVB, Can you let me know the MultiLoad version, the Teradata DBS version  and the platform MulitLoad was running on? Thanks! --Ivy.
2928 Apr 2014 @ 04:39 PDTToolsReplyMultiload errorHidivyag, This could be an error issued by Informatica. You might want to check if the "MLOAD connection" terminated with certain errors. Thanks!
2806 Mar 2014 @ 09:35 PSTToolsReplyStarting TPUMP on Windows 2008 R2 failsHi, TPump should be able to run on this platform. Please re-install all 32-bit packages (including dependencies, like TERAGSS, TDICU, TDCLI, TD Dataconnector(PIOM) etc and re-try. Thanks! --Ivy.
2726 Feb 2014 @ 02:02 PSTToolsReplyFast export and mload in vartext mode - Data item too large for field issueHi Cheeli, Your fastexported data file is not in VARTEXT format, so your mload job failed. Here is a matching FastExport script and corresponding MultiLoad script. FastExport: .LOGTABLE FELOG11...
2603 Feb 2014 @ 01:12 PSTToolsReplyMload - execute a file in batch mode, invalid statement was foundHi Cheeli, Can you try changing the following statements --errortables samples.ET_ITEMPPI SAMPLES.UV_ITEMPPI SAMPLES.WT_ITEMPPI; -- values (:L_ORDERKEY, :L_PARTKEY, :L_QUANTITY, :L_LINESTATUS, :...
2527 Jan 2014 @ 03:04 PSTToolsReplyMload upsert - 6705 - SAP BW as sourceHi Cheeli, Please refer to "Handling Teradata MultiLoad Errors" section in MultiLoad manual to for error recroding. Thanks! --Ivy.
2414 Oct 2013 @ 02:23 PDTToolsReplyMload - errorlimit applicable only for ET during acquisition phase or alsoHi Cheeli, Errorlimit option only applies to teh records in ET during acquisition phase. Thanks!  
2314 Oct 2013 @ 02:00 PDTToolsReplyMload - work table formatHi Suresh, Only the record(s) meet(s) the APPLY-WHERE condition will be sent to DBS. Acquisition phase is not only a client operation, client MultiLoad also sends the data to DBS, and DBS will co...
2210 Oct 2013 @ 01:05 PDTToolsReplyMLOAD ISSUE Hi, Can you share with me your MLOAD version, platform, script and datafile? Thanks!
2108 Oct 2013 @ 10:32 PDTToolsReplyMload - error treatment in DML label clauseHi Cheeli, MARK/IGNORE DUPLICATE ROWS has no effect if the table is a multiset table (which allows duplicate rows). IGNORE DUPLICATE ROWS has no effect if the table has a unique primary inde...
2008 Oct 2013 @ 10:23 PDTToolsReplyMload - Access module error '33'Hi Cheeli, This will need be checked from Informatica manual if any. Thanks! --Ivy.
1926 Sep 2013 @ 12:57 PDTToolsReplyMload - work table formatHi Cheeli, Only the record(s) meet(s) the APPLY-WHERE condition will be sent to DBS. In you case, the work table won't contain 100 records. The work table should have equivalent content to ta...
1825 Sep 2013 @ 02:36 PDTToolsReplyTpump failed with UTY8001 RDBMS failure in Macro Build: 2673This issue had been resolved. From: Gerritson, Peter Sent: Wednesday, September 18, 2013 7:59 AM To: Yuan, Ivy Subject: RE: RDBMS failure in Macro Build: 2673 Ivy: He switched versions and...
1712 Sep 2013 @ 03:27 PDTToolsReplyMload - no. of records in ET table <= errorlimitHi Cheeli, Yes, MultiLoad will run to success if If the no. of records in ET (Acquisition Error Table) <= errorlimit specified; Yes, If it runs to success,  it will retain the error table ...
1604 Sep 2013 @ 10:43 PDTToolsReplyMload - identify the erroneous record using the sourcesequence in InformaticaHi Cheeli, Please refer to "Handling Teradata MultiLoad Errors" section in MultiLoad manual for further information, there is an example on how to determine the cause of errors: http://...
1504 Sep 2013 @ 10:10 PDTToolsReplyMload error - 2794 - UPI is an identity columnNo, I did not see this before. BTW, have you specified both GENERATED ALWAYS and NO CYCLE? How many rows were you loading? Thanks!
1423 Aug 2013 @ 11:27 PDTToolsReplyMload error - 2794 - UPI is an identity columnHi Cheeli, To guarantee uniqueness, please specify GENERATED ALWAYS and NO CYCLE. Yes, the identity column has respective values in the work table. Before you make the decision to check the ...

Pages