Working with Multi Load and its Structure in TeraData

Multi Load

• It is cusion of Fast load To load bulk data multiple tables
• Mload Loads max 5 Tables at a Time
• Multi load supports, INSERT, UPDATE, and UPSERT[update else insert]
• It is fully Automatic restartable
• It loads data into empty/populated tables
• It loads duplicate record as well
• It supports input module programming
• Max15 FLML, FEXP Script we can execute at a time
• It processes the data Block by block
• It reduces the utilization of P.E
• It Keeps BYNET Activity low by Running Amp local processing
• There is no transient General overhead
• It performs over multiple DML Operations, multiple tables by taking table data from a single file
• Max 20 DML Operation it supports a script.
• It Runs in 5 Phases and loads error data to error tables
• Multi load support NUSI Data loading

Inclined to build a profession as Teradata Developer? Then here is the blog post on, explore Teradata Training

Navigation

Start Run   M Load

Start   programs   Tera data client    Tera data m load  

Limitation

• If the table contains USI, RI, JI, HI, And Triggers, it cannot load the data
• It does not support Aggregate exponential operations
• Import task Requires the usage of P.I
• Concatenation input data file not allowed

Note

Mload supports NUSI And soft Baronial Integrity  

MLOAD Structure

.Logon<>

.Log Table<Restart Log Table>

.Begin Import Delete MLoad

Tables Table1, Table2,---Table5

Work Tables work table1, work table2,----Work table5

Error tables ET-Table1---ET-Table5

UV-Table1---UV-Table5

.Layout<Layout Name>

.Field

.Filler

.DML Label<Label name>

<DML Operation>

.Import In file<File Name>

From m  For N thru K

Format<Fast load/Binary/text/in Format/Var text>

Layout<Layout name>

Apply<Label Name>[Where condition]

.End M Load

.Logo FF  

.Field

.FIELD[Field Name][Start-pos Data Desc]

{NULLIF Null expr}

[Drop{Leading/trailing}{Blanks/Nulls}]

[[And]{Leading/training}{Blanks/Nulls}]  

.FILLER

.FILLER[Field name][Start pos Desc]  

Note

From MàStarting positions

For NàThe number of Records To Read

Thru KàTill end Record  

Ex: 6 To 8^th Record

From 6 for 2 these 8  

M Load Conditional Logic

.IF<Condition>Then;

<Statements>

.Else;

< Statements >

.End if;  

Teradata DBA Interview Questions

Support Environment system variables

$Sys Date  System Date in the Format yy/mm/dd $Sys

Date4  System Date in the Format yyyy/mm/dd $Sys

Date  System Day in the Format Day(3)

Ex: IF Friday Then ’Fri’

$SySOS  HOST operating system

$Sysuser  Unix/mvs user

$SYSRC  Return code    

M Load variables

$SYSDELCNT  Delete COUNT

$SYSINSCNT  INSERT COUNT

$SYSUPDCNT  UPDATE COUNT

$SYSETCNT  ERROR Table COUNT

$SYS UVCOUNT  UV Table COUNT  

Releasing LOCKS in m Load

IN ACQUISION

Release m load<Table1>…..< Table 5>  

IN APPLY

Release m load<Table1>…..< Table 5>

IN APPLY  

NOTE:

WE Can use this release m load command only in “BTEQ”