Fast load process and phases
- It processes the data block by block
- 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
- It loads only one table and the table should be empty
- It does not support SI, RI, JI, HT, And Trigger
- No Amp should Go Down when a Fast load is processing
- 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
- It applies “Access Lock” on the table in AQuision phase
- 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
- Select*From Erparty4;//[select *From sys Admin. Fast Log]
[//select *From ET-Party41]
- F5 Press
2nd Error table data
Select* From UVParty4
Generally problem in the Lab Rectification
- Syntactical error in script
- Record parcel length does not match
- If the defining are using class structure length or input file, Data file not match, then we get the error
- Input number of values not matching with column names
Ex: Insert into party(5Columns)Values(4Columns)
For an in-depth knowledge, click on below