Group Discounts available for 3+ students and Corporate Clients

Fast load process and phases in TeraData

Fast load process and phases

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

 

Screenshot_95

 

 

Phases

1.ACQVISITION PHASE[INSERT phase]

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

 

Screenshot_96

 

 

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]

 

Screenshot_97

 

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 phases

 

 

Fast load Limitations

  1. It loads only one table and table should be empty
  2. It does not support SI,RI,JI,HT And Trigger
  3. No Amp should Go Down when Fast load is processing
  4. The Table is multiset, you try to store duplicate data, those records does not move in to any error tables, but number of duplicate 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:\BTEQ\Conn.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:\Fastload\data-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

 

 

Importing variable Text Data

[6th Script in the Project]

.Set Record Vartext”,”;

Session4;

.Run File c:\BTEQ\Conn.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 load\data-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 ET-Party41]

  1. F5 Press

 

 


Screenshot_98 

 

 

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)

 

 

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Fast load process and phases in TeraData"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Support


    Please leave a message and we'll get back to you soon.
    Three + 6