import huge data very quickly -- Fastload/Tpump/MLOAD

Tools
Enthusiast

import huge data very quickly -- Fastload/Tpump/MLOAD

Hi All, 

can someone throw light on the below task with an example please?

Task : Fastload/TPUMP/MLOAD script for importing couple of hundered thousands of records very quickly

your inputs are highly appreciated.

Thanks in advance for your help.

Regards,Srini

18 REPLIES
Junior Contributor

Re: import huge data very quickly -- Fastload/Tpump/MLOAD

Hi Srini,

you have to add more details.

If the target table is empty a FastLoad will be the fastest way, otherwise it depends...

Dieter

Enthusiast

Re: import huge data very quickly -- Fastload/Tpump/MLOAD

Hi Dieter, 

I am exactly looking for a bulk import script, in this case which can be best with Fastload/TPUMP/MLoad ? 

please suggest and help me with the script.

Thanks,

Enthusiast

Re: import huge data very quickly -- Fastload/Tpump/MLOAD

Hi Dieter, 

In this case the focus is on importing couple of hundred thousands of records very quickly, what can be the potential script with respect to Fastload/TPUMP/MLOAD.

please help me with the script. 

Thanks,

Teradata Employee

Re: import huge data very quickly -- Fastload/Tpump/MLOAD

Our utility reference manuals have all of the information you need.

You may find them here:

http://www.info.teradata.com/

-- SteveF
Enthusiast

Re: import huge data very quickly -- Fastload/Tpump/MLOAD

Hi,

I was trying to paste a sample fastload script but unable to post it. anyway you can consult the following URL for a quick start:

http://teradataexample.blogspot.com/2012/07/how-to-write-sample-fastload-script.html

Khurram
Enthusiast

Re: import huge data very quickly -- Fastload/Tpump/MLOAD

Hi msk.khurram, 

the script provided is helpful. 

what can be the datatype of a columns which have url (s) as it values?? i think it can be varchar, can you pls suggest me ..

Thanks,

Enthusiast

Re: import huge data very quickly -- Fastload/Tpump/MLOAD

Yes the DEFINE part contains all the definitions of columns coming from file, and are VARCHAR.

 

DEFINE

NAME (VARCHAR(20)),

DOB (varchar(20))

 

In the insert part you need to cast the values as is done in the script as follows:

 

INSERT INTO tl_62917_dly1_qrmdb.fld1

VALUES

(

:NAME,

:DOB(date, format 'ddmmyyyy')

);

 

 

Khurram
Enthusiast

Re: import huge data very quickly -- Fastload/Tpump/MLOAD

My question is when the value of a field is a hyperlink(URL), can we use the varchar datatype ?

Enthusiast

Re: import huge data very quickly -- Fastload/Tpump/MLOAD

URLs are generally alphanumeric strings... so of course you can use varchar!