Fast load process and phases in TeraData

Fast load process and phases

1. It processes the data block by block
2. It Runs in 2 phases

     

Phases

1.ACQVISITION PHASE[INSERT phase]

[Insert phase]{FileAmp}” Access lock” on target

     

Row available in Amp and Disk but not in sequence

Data available in the Amp and disk but not in stored order    

 

2) Application phase

[End loading phase]

   

 Rows in amp and Disk are in sequence

 Data in the Amp Disk are in stored order  

Note

Refer to the material for more Description of each phase    

Fast load Limitations

1. It loads only one table and the table should be empty
2. It does not support SI, RI, JI, HT, And Trigger
3. No Amp should Go Down when a Fast load is processing
4. The Table is a multiset, you try to store duplicate data, those records do not move into any error tables, but the number of duplicates mentioned in the Log File.

Fast load Locks

1. It applies “Access Lock” on the table in AQuision phase
2. It applies “WRITE Lock” And Application phase

 Ex: Importing unformatted Data)(5^th Script in the project)

.Set Record unformatted;

.Run File c:BTEQConn.Txt;

Database vinayaka;

Drop Table erparty3;

Drop table uvparty3;

Delete from party3;

Begin loading party3

Error files exparty3,Uvparty3

Checkpoint10;

Define

i-pid(char(1)),

i-PNUM(char(5)),

i-PCode(char(2)),

i-Pinc(char(5)),

CRLF(Char(2))

[CRLF=Enter character]

File=c:Fastloaddata-fixed.txt;

Insert INTO party3

(Party id, party name, email, party code, Jdate, party income user created)

Values(

: I-Pid,

: I-PNm,

‘Tera data vinay@yahoo.co.in’,

: I-Pcode,

Current-Date(Formal’yyyy-mm-dd’),

: I-PINC,

);

END Loading;

.LOGOFF    

 

Inclined to build a profession as Teradata Developer? Then here is the blog post on, explore Teradata Training

 

Importing variable Text Data [6^th Script in the Project]

.Set Record Vartext”,”;

Session4;

.Run File c:BTEQConn.TxT;

Database vinayaka;

Drop table erparty4;

Drop table UV party4;

Delete from party4;

Begin Loading party4

Error files erparty4, UVParty4

Check point 10;

Record2;

/*errlimit10;*/

Define

i- pid (Varchar(30)),

i-PNM(Varchar(30)),

i-PCode(Varchar(30)),

i-pinc(Varchar(30)),

File=c:Fast loaddata-vartext.txt;

Insert into party4

(Party id, party name, email, party code, J date, party income, user created)

Values

(

:i-pid,

:i-PNM,

‘Tera data vinay@yahoo.co.in’,

31300,

Current-Date(Format’yyyy-mm-dd’),

:i-pinc,

);

End Loading;

.LOGOFF    

To see the data in error tables

1. Select*From Erparty4;//[select *From sys Admin. Fast Log]

[//select *From ET-Party41]

2. F5 Press

 

         

2^nd Error table data

Select* From UVParty4  

Generally problem in the Lab Rectification

1. Syntactical error in script
2. Record parcel length does not match
3. If the defining are using class structure length or input file, Data file not match, then we get the error
4. Input number of values not matching with column names

Ex: Insert into party(5Columns)Values(4Columns)    

For an in-depth knowledge, click on below

• BTEQ Features in Teradata
• Working with Utilities in TeraData