Answered Questions

  • 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?

    Star 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 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

    CHetan

    • 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....

  • After creating tables dynamically in the Teardata, where is the GRANT table option usually done ? When tables are newly created, what is the default role and what the default privileges which get assigned ?

    Neelima Dahi

    • Aug 10th, 2007

    The GRANT option for any particular table depends on the privilages of the user. If it is an admin user you can grant privilages at any point of time.The deafult roles associated with the newly created tables depend on he schema in which they are created.