Multi load tasks
There are 2 types of Task
A)IMPORT TASK
- It perform, insert, update, Delete And up sert operation
- Max 5 Tables it operate, it Runs in 5 phase it uses
- Apply command for its operations
- It’s operations are based on PI, But it cannot update the PI
Delete Task
- It Delete the data only one table
- It is faster than import delete, because it is global all Amp delete
- Deletion Based on UPI Not allowed
- Delete Task does not Require AQuision phase, so it Runs in 4 phases
- 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
DELETE TASK
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
0 Responses on Multi load tasks in TeraData"