Fast load process and phases in TeraData

Ratings:
(4)
Views:205
Banner-Img
  • Share this blog:

 

Fast load process and phases

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

  Fast load Process and Phases    

Phases

1.ACQVISITION PHASE[INSERT phase]

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

  ACQVISITION PHASE    

2Row available in Amp and Disk but not in sequence

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

 

2) Application phase

[End loading phase]

  Application Phase  

2 Rows in amp and Disk are in sequence

2 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)(5th 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 [6th 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]

  1. F5 Press

 

    Lob Information     

2nd 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

About Author
Authorlogo
Name
TekSlate
Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.