The basic concept is
FastLoad used to load and empty table and none of the secondary indicis are allowed on the target table.and it can load only 1 table.
Multiload can load already populated table and can load upto 5 tables.NUSI is allowed on the target table.
in multiload, as the target table can contain NUSI, it has to load both the subtable and the base table.where as in fastload no need of subtable as NUPI is not allowed.
one more difference is multiload uses two work tables.
the purpose of work tables is to hold the DML requests and the input data that is ready to APPLY to AMPS.
So multiload has to first load the worktable and then the target table.
loading worktable is just like fastloading the work table.So it will take twice the resources and hence the performance is less compared to fastload
Subscribe to:
Post Comments (Atom)
Good job!! Keep writing!!
ReplyDelete