Fload, Mload and error tables
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?
Editorial / Best AnswerSHUBH25
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 error
MultiLoad 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.
- Triggering events in Oracle
- Pseudocodes and flowcharts
- Where does Oracle stores the tables ?
- Error message
- Design a dwh table based on the given source
- Source file and 3 output tables records problem
- PostgreSQL - error message
- While doing conversions different columns will load into interface tables automatically or not?
- Trouble creating queries
- How do we use or operator with desc programming.
- How to solve the function getbyidasync has invalid parameters in office app?
- Write a program that calculates and prints the bill ?
- How to avoid JVM error when opening selenium using Java?
- What are the situations in which lightweight udp protocol would be acceptable
- SAP FICOew
- Database design questions
- Peoplesoft instance from db2 to Oracle
- Repository services not started
- Loadrunner fails on 302 redirect. Is this because of ssl?
- Installing mercury quality center