Fast load process and phases in TeraData

1. It process 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 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)(5^th 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

[6^th 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 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)