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 2Run  2 M Load

Start  2 programs  2 Tera data client  2  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 8th 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 2 System Date in the Format yy/mm/dd $Sys

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

Date 2 System Day in the Format Day(3)

Ex: IF Friday Then ’Fri’

$SySOS 2 HOST operating system

$Sysuser 2 Unix/mvs user

$SYSRC 2 Return code    

M Load variables

$SYSDELCNT 2 Delete COUNT

$SYSINSCNT 2 INSERT COUNT

$SYSUPDCNT 2 UPDATE COUNT

$SYSETCNT 2 ERROR Table COUNT

$SYS UVCOUNT 2 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”