Multi load tasks in TeraData

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

 

Multi load tasks

There are 2 types of Task  

A) IMPORT TASK

  1. It performs, inserts, update, Delete, And upsert operation
  2. Max 5 Tables it operates, it Runs in 5 phase it uses
  3. Apply command for its operations
  4. Its operations are based on PI, But it cannot update the PI

B) Delete Task

  1. It Deletes the data only one table
  2. It is faster than import delete because it is global all Amp delete
  3. Deletion Based on UPI Not allowed
  4. Delete Task does not Require an AQuision phase, so it Runs in 4 phases
  5. A Simple delete Tag is submitted to each Amp so that is Global all amp delete[Import delete does not satisfy this]

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

IMPORT TASK

Import task      

DELETE TASK

Delete task    

MLOAD Delete

.RUN FILE C:BTEQConn.txt;

.LOGTABLE VINAYAKA.PLOG;

DATABASE VINAYAKA;

.IF’$SYSDAY’ NE’FRI’THEN

.Display ’TODAY IS NOT FRIDAY, SO LOAD IS NOT HAPPENING’

TO File c:Data—LogTROCKFILE.TXT;

.END IF;

.BEGIN DELETE MLOAD TABLES PARTY111;

DELETE FROM PARTY111;

.END MLOAD;

.LOGOFF; *Check TEMPORAL TABLE

TEM PORAL, DATA MOVER TABLE    

For an in-depth knowledge click on below

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.