0 - 34 of 34 tags for multiload

I have a very simple working MLOAD and have a new requirement to block data from being INSERTED.  I see many examples where the WHERE of an APPLY statement is specified as equality (=) and am sure I've done that in the past successfully, but my new requirement is to skip based on 'not equal to'.
Layout of file:

Hello All,
I am running a mload job. In the source file, the fields are having different data types like Decimal, Char & Varchar. But when i am running the job, major volume of records are going to error tables with error code 2797 (saying MLoad MARK MISSING UPDATE). That means its not finding records with given where conditions.

Hello Everyone.

Friends, I have the following problem: I have a final table, where some values are rounded wrongly. There is no transformation of these values. The tables have the same data type, decimal (9.2) and FastExport it converts to the same data type. An example I got was a value of 46.23.

Dear All,
I am trying to use the below records to load in to teradata database using Multiload option
When i tried to load using Multi load the inserts are done automatically to the Error tables. The reason is due double quoted vaules.

I have a scenario at hand:-
Source: 9 Binary Flat Files (From Mainframe Source Systems)
Target: 1 Teradata Table
ETL Operations: Insert / Update / Delete using Informatica Workflows – Teradata MLOAD INSERT / UPDATE Connection String & Teradata MLOAD DELETE Connections String

Hello All,
Teradata Utilities are specialised tool for loading or exporting huge volume of data as compared to conventional SQL tools like SQL Assistant & BTEQ. I wish to learn the fundamental performance gain reason between them. I have provided my understanding on them below. I would appreciate any addition/correction to them.

Greetings experts,
I am facing the following issue in TD Demo version 13.0 , windows 7
Scenario:  Fast exporting from a table samples.itemppi_bkp in "mode record format text" (vartext separated by ,) and then using this file as source for mloading into target table samples.itemppi_wodate.  

Hi Folks, 
Can anyone explain the significance of MODE and FORMAT in Utilities like Fast Export and Multi load ?
And what are the various MODE and FORMAT are avilable at this end ?
I have seen some scenario's where RECORD has been used as MODE.

Dear friends, help me to understand the following error during Multiload Acquisition Phase:
Access module error '60' received during 'pmReadDDparse' operation: 'Column length error, row not returned'
is it a problem with a file? or Access?
thank you in advance for your answer

I'm using this MLOAD script:






    VALUES ( :FIELD1 ) ;

Hi -
I am new to working with Teradata. I tried searching the forums for how to create a batch file to initiate a MultiLoad script but was not very successful. I would like to use Windows scheduler to kick off a MultiLoad script to populate tables over night.
Does anyone have an example of a batch file initiating MultiLoad?

Is there any way to measure the total AMPCPUTIME consumed by any MLOAD/FLOAD/FEXP job post completion? The values from the dbql(sum of ampcputime for a particular LSN number) does not seem right.
I also tried dbc.acctg. There too, the values seem low.

The Teradata MultiLoad Notify Exit Routine has some issues in the 14.00 and 14.10 releases because of enhancements to the MultiLoad notify events logic. This document discusses the enhancements and issues in detail.

Does anyone know why the mload delete task does not allow delete based on a primary index?
I need the answer just out of curiosity.

I'd like to know behind covers - how these 2 utilites differ. I am aware of the glaring differences : empty tables vs non , single vs multi-table , upserts, fastload locking etc.

For an upcoming project, I am required to pull data from a table on database A and load it into a table on database B.
I used FASTLOAD in my scipt for this purpose. It works fine, but in case there is any error and the script fails, the target table gets locked and we have to drop and create the table to use it again.

Hi everyone,
I would like to know if it's possible to know with some system table (such as dbc.dbqlogtbl or similar) to get the number of sessions opened by a MultiLoad/FastLoad/FastExport/TPT job.
In the dbqlogtbl it seems that Teradata puts only the father session which will create the child sessions...

Teradata has completed a major compiler conversion effort that should be completely transparent to customers, yet they are the main beneficiaries.  This article:

  • Provides some historical background and context,
  • Discusses the reasons we switched compilers,
  • Identifies certain behavioral changes that were unavoidable,
  • And, finally, answers a few technical questions related to the overall process.

The venerable IBM mainframe was the original client platform developed for the Teradata RDBMS via channel-attached connections way back in the 1980s. Although we now support a wide range of client platforms using network-attached connections, a significant segment of our customer base continues to use mainframe clients.

The Period data type is supported by Teradata Multiload as of TTU 13.0. A period represents an interval of time. It indicates when some particular event starts and when it ends. It has a beginning bound and an (optional) ending bound (the period is open if there is no ending bound). The beginning bound is defined by the value of a beginning element. The ending bound is defined by the value of an ending element. Those two elements of a period must be of the same type that is one of the three DateTime data types: DATE, TIME, or TIMESTAMP.

Teradata FastLoad has a feature named Tenacity that allows user to specify the number of hours that FastLoad continues trying to log on when the maximum number of load operations is already running on the Teradata Database.

By default the Tenacity feature is not turned on. The feature is turned on by the script command:


Can I use '||'  as delimiter in Mload script?

Pls reply asap.

Thanks in advance.

I have data exported from oracle to a pipe delimited flat file with some fields spanning to multiple lines which is causing an issue in MLoad whereby linefeeds are present in the data causing MLoad to fail.

Is there a command (or method) within MLoad that will allow our script to ignore the linefeeds between delimiters within the flat file?

This presentation describes, in detail, the various load utilities supported by Teradata.

I have been asked by the server admins to provide a space requirement to install the following Teradata 12 utilities on a SUN Solaris SPARC server:

(1) CLI and related security libraries
(2) BTEQ
(3) FastLoad
(4) MultiLoad
(5) FastExport

This book provides information about Teradata MultiLoad, a product that provides an efficient way to deal with batch maintenance of large databases. Teradata MultiLoad is a command-driven utility for fast, high-volume maintenance on multiple tables and views in a Teradata Database.

This book provides information on how to use Teradata Parallel Transporter (Teradata PT), an object-oriented client application that provides scalable, high-speed, parallel data extraction, loading, and updating. These capabilities can be extended with customizations or third-party products.

This book provides information about Teradata Parallel Data Pump (TPump), a data loading utility that helps you maintain (update, delete, insert, and atomic upsert) the data in your Teradata Database. TPump uses standard Teradata SQL to achieve moderate to high data-loading rates.

This book provides information on how to use the Teradata Parallel Transporter (Teradata PT) Application Programming Interface. There are instructions on how to set up the interface, adding checkpoint and restart, error reporting, and code examples.

The Teradata Multiload utility provides the capability to perform batch maintenance on tables (insert, update, delete and upsert). It loads data from external sources and provides the capability to restart jobs interrupted by errors, exceptions and failures.

This book provides reference information about the components of Teradata Parallel Transporter (Teradata PT), an object-oriented client application that provides scalable, high-speed, parallel data extraction, loading, and updating. These capabilities can be extended with customizations or with third-party products.

This book provides reference information about the components of Teradata Parallel Transporter (Teradata PT), an object-oriented client application that provides scalable, high-speed, parallel data extraction, loading, and updating. These capabilities can be extended with customizations or with third-party products.

A high-availability system must have the ability to identify and correct errors, exceptions and failures in a timely and reliable manner to meet challenging service level objectives. The Teradata database and the utilities and components (used to both load and access data) provide capabilities to implement reliable error and exception handling functionality. These capabilities combined with a well designed high availability architecture allow a Teradata Active Enterprise Intelligence (AEI) system to meet the service level objectives required to support mission critical business processes.

Please note:  This content does not apply for sites on Teradata 13.10 or later releases.