Working with Multi Load and its Structure in TeraData

Ratings:
(4)
Views: 1064
Banner-Img
Share this blog:

 

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”

You liked the article?

Like: 0

Vote for difficulty

Current difficulty (Avg): Medium

EasyMediumHardDifficultExpert
IMPROVE ARTICLEReport Issue

About Author

Authorlogo
Name
TekSlate
Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.