Group Discounts available for 3+ students and Corporate Clients

Multi load tasks in TeraData

Multi load tasks

There are 2 types of Task

 

A)IMPORT TASK

  1. It perform, insert, update, Delete And up sert operation
  2. Max 5 Tables it operate, it Runs in 5 phase it uses
  3. Apply command for its operations
  4. It’s operations are based on PI, But it cannot update the PI

 

Delete Task

  1. It Delete 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 AQuision phase, so it Runs in 4 phases
  5. A Simple delete Tag is sub mitted to each Amp so that is Global all amp delete[Import delete does not safisfy this]

 

IMPORT TASK

Screenshot_107

 

 

 

DELETE TASK

Screenshot_108

 

 

MLOAD Delete

.RUN FILE C:\BTEQ\Conn.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—Log\TROCKFILE.TXT;

.END IF;

.BEGIN DELETE MLOAD TABLES PARTY111;

DELETE FROM PARTY111;

.END MLOAD;

.LOGOFF;

*Check TEMPORAL TABLE

TEM PORAL,DATA MOVER TABLE

 

 

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Multi load tasks in TeraData"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Support


    Please Enter Your Details and Query.
    Three + 6