-
Fload, Mload and error tables
How many error tables are there in fload and what are their significance/use?Can we see the data of error tables?How many error tables are their in mload and what is there use?When mload job fails, can we access mload tables? If yes then how?
Read Best Answer
Editorial / Best Answer
SHUBH25- Member Since Feb-2008 | Feb 15th, 2008
Fload uses 2 error tables
Error table 1: where format of data is not correct.Error table 2: violations of UPI
Mload also uses 2 error tables (ET and UV), 1 work table and 1 log table
1. ET TABLE - Data errorMultiLoad uses the ET table, also called the Acquisition Phase error table, to store data errors found during the acquisition phase of a MultiLoad import task.
2. UV TABLE - UPI violations
MultiLoad uses the UV table, also called the Application Phase error table, to store data errors found during the application phase of a MultiLoad import or delete task
3. WORK TABLE - WT
Mload loads the selected records in the work table
4. LOG TABLE
A log table maintains record of all checkpoints related to the load job, it is essential/madatory to specify a log table in mload job. This table will be useful in case you have a job abort or restart due to any reason.
ShubhangiCHetan
- Jun 9th, 2017
There are 2 error tables in Fastload, Error table 1 significance is to capture datawhich do not match the speciied datatype, and Error table 2 is for the Uniqueness constraint.. In case you have UPI d...
prasadh
- Oct 10th, 2014
In fload and multi load we have 2 error tables for a target table, if script run successfully with return code 0 we can see the error tables data(no errors tables will dropped).
tables are locked if script fails we can't see them its under loading.... -
