As per my understanding the fastload has 2 phases begin loading and end loading, now where is the data stored at the
end of the begin loading phase in case of multifile load i have noticed that the table size remains zero unless the end loading
command is executed so where is all the data stored in spool or perm ?
Fastload works differently than multiload. As noted above, fastload loads direct into the target table. Multiload loads into a work table first and then moves the data into the target table during the apply phase.
I'm new to Teradata. Please excuse me if I ask some silly questions. Below are my questions:
1. Can I use "CREATE" in Fastload and Multiload? If not, how the error tables getting created?
2. In Multiload--In which phase error tables gets populated?
3. If I want to load 25 records into a table. Which utility is faster --Fastload or Multiload?
4. If a file contains 100 records and I want to load only 60 records (skipping first 20 and last 20). How can I achieve this using Fastload, Multiload and BTEQ?
#1: Yes, but you don't create the error tables, this is done automatically by the tool.
You just might change their default names.
#2: MLoad: aquisition phase -> ET-table and application phase -> UV-table
#3: BTEQ :-)
Both MLoad and FastLoad need to create additional tables (error/work/log-tables), but FastLoad should aways be faster.
.IMPORT ... SKIP 20
.RECORD 20 THRU 80
.IMPORT .... FROM 20 THRU 80 (or FROM 20 FOR 60)
Fast load has two phases. 1. Acquisition 2.Application
In acquisition phase data loads into Amps with out sort. In application phase data loaded into target table with proper hasing and all.
So in two phases data is not load into any wrok table or temp table.