GeekInterview.com
Series: Subject: Topic:
Question: 15 of 36

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?
Asked by: rakesh5300 | Member Since Sep-2007 | Asked on: Feb 8th, 2008

View all questions by rakesh5300

Editorial / Best Answer

Answered by: SHUBH25

View all answers by SHUBH25

Member Since Feb-2008 | Answered On : 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 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.

Shubhangi

Showing Answers 1 - 9 of 9 Answers
SHUBH25

Answered On : Feb 15th, 2008

View all answers by SHUBH25

Fload uses 2 error tablesError table 1: where format of data is not correct.
Error table 2: violations of UPIMload also uses 2 error tables (ET and UV), 1 work table and 1 log table1. 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 violationsMultiLoad 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 task3. WORK TABLE - WTMload loads the selected records in the work table4. LOG TABLEA 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.Shubhangi

Yes  5 Users have rated as useful.
  
Login to rate this answer.
pritampatil

Answered On : Aug 12th, 2008

View all answers by pritampatil

Fast load (Fload) requires two error tables that you specify in the Beging Loading Command.ERROR TABLE 1 - Contains one row for each row which failed to be loaded due to contraint violations or Transalation error.ERROR TABLE 2 - Captures rows that contains duplicate Values for UPIs.Multi Load (Mload) have two error tables, that are created for each target table.ET_Tablename - It logs errors that are occurs during the acquisition phase.UV_Tablename- It logs errors & exceptions that occurs during the apply phase.

  
Login to rate this answer.

Two error tables can be define in multi load job they are: (i) Acquisition error table and (ii) Application Error table.

  
Login to rate this answer.
geetha_mca

Answered On : Dec 30th, 2008

View all answers by geetha_mca

In Fload there are 2 error table.
Error table1: Contains one row for each row which failed to be loaded due to
constraint violations or translation errors
Error table2: For non-duplicate rows, captures those rows that cause a UPI
duplicate violation.
Its possible to see the error data.

  
Login to rate this answer.
girishnayak

Answered On : Jun 27th, 2009

View all answers by girishnayak

Ideally, there are 2 error tables in Fload. These table contains the details about the data parcel from source to the target table. We can view the data in error table.It has below detailsErrorCode, ErrorFieldName, and DataParcel

  
Login to rate this answer.

FASTLOAD:Error Table 1Contains one row for each row which failed to be loaded due to constraint violations or translation errors. Error Table 2Captures rows that contain duplicate values for UPIs

  
Login to rate this answer.
anil_k_nayaka

Answered On : Jan 25th, 2012

View all answers by anil_k_nayaka

There are 2 types of ERR tables created in both Mload & Fload
they are
ERR1:-
Created due to BAD data/Constraint Violation & this table Contains this type of data
ERR2:
Created due to duplicate data..... when the input contains duplicate records, it load ones a set of data to the target table & the duplicate data to the ERR2 table.


Answer2:-
Yes mload & fload tables can be accessed when this aborts happens.
If there is a lock on this table due to mloa or fload. Below are the procedures to release them.
MLOAD:- RELEASE MLOAD table_name;
FLOAD:- DROP & recreate the table to restart fload.

Yes  1 User has rated as useful.
  
Login to rate this answer.

How many error tables are there in fload and what are their significance/use?

FLOAD needs 2 error tables for its execution. 1 Error table for data issue and another error table for UPI violation

Can we see the data of error tables?

Yes, we can. After the completion of the Fload, it there are values in the error table, then error tables doesnt get dropped automatically, bacause FastLoad wants us to review the errors and manually drop the same. Just select from the table name to check the values.
Well you can Igrnore the Errors as well by expicitly mentioning the same while writing the FLOAD Script.

How many error tables are their in mload and what is there use?

For Multiload Utility, 2 Error tables are required for each target table, if you dont explicitly mention the names Mload will automatically create the same with ET_ and UV_. The job of this error tables are similar to that of FLOAD i.e. ET_ Error table is for data issue and UV_ error table is for UPI violation.

When mload job fails, can we access mload tables? If yes then how?

Once MLOAD Job fails we can access the taget table after Releasing the Mload lock. Mload at Phase 3 (i.e. Acquisition Phase) locks the target table because at Phase 4 (Application Phase) , data is loaded in the Target table from the work table. So if Mload fails at phase 3 or 4, then Mload locks needs to be released.

Command : Release Mload

  
Login to rate this answer.
Umar

Answered On : Oct 8th, 2013

My question is what if fastload fails, how can we access fastload error table ??? Quick response would be appreciated.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.