2019年整理Teradata数据仓库简介资料课件.pptVIP

MultiLoad ? ? ? ? ? ? Batch mode utility that runs on the host system. FastLoad-like technology – TPump-like functionality. Supports up to five populated tables. Multiple operations with one pass of input files. Conditional logic for applying changes. Supports INSERTs, UPDATEs, DELETEs and UPSERTs; typically with batch inputs from a host file. Affected data blocks only written once. Host and LAN support. Full Restart capability. Teradata DB HOST INSERTs TABLE A TABLE B TABLE C TABLE D TABLE E ? ? ? ? Error reporting via error tables. ? Support for INMODs. MULTILOAD UPDATEs DELETEs MultiLoad Limitations ? No data retrieval capability. ? Concatenation of input data files is not allowed. ? Host will not process arithmetic functions. ? Host will not process exponentiation or aggregates. ? Cannot process tables defined with USIs, Referential Integrity, Join Indexes, Hash Indexes, or Triggers. ? Import tasks require use of Primary Index. Basic MultiLoad Statements . LOGTABLE [ restartlog_tablename ] ; .LOGON [ tdpid/userid, password ] ; .BEGIN MLOAD TABLES [ tablename1, ... ] ; .LAYOUT [ layout_name ] ; .FIELD ….. ; .FILLER ….. ; .DML LABEL [ label ] ; .IMPORT INFILE [ filename ] [ FROM m ] [ FOR n ] [ THRU k ] [ FORMAT FASTLOAD | BINARY | TEXT | UNFORMAT | VARTEXT c ] LAYOUT [ layout_name ] APPLY [ label ] [ WHERE condition ] ; .END MLOAD ; .LOGOFF ; .FIELD fieldname { startpos datadesc } || fieldexp [ NULLIF nullexpr ] [ DROP {LEADING / TRAILING } { BLANKS / NULLS } [ [ AND ] {TRAILING / LEADING } { NULLS / BLANKS } ] ] ; .FILLER [ fieldname ] startpos datadesc ; FastExport ? Exports large volumes of formatted data from Teradata to a host file or user-written application. ? Takes advantage of multiple sessions. ? Export from multiple tables. ? Uses Support Environment. ? Fully automated restart. ? Uses one of the “Loader” slots. FastExport Ter