Answered Questions

  • Conditional load of records in Datastage

    Source has sequential file stage in 10 records and move to transformer stage it has one output link 2 records and reject link has 5 records ? But i want remaining 3 records how to capture

    Shirisha

    • Oct 10th, 2012

    You can choose O.W option in constraints, so remaining records you will get.

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

  • How did you handle an 'Aborted' sequencer?

    In almost all cases we have to delete the data inserted by this from DB manually and fix the job and then run the job again.

    Star Read Best Answer

    Editorial / Best Answer

    ritu singhai  

    • Member Since Jul-2008 | Jul 5th, 2008


    Have you set the compilation options for the sequence so that in case job aborts, you need not to run it from from the first job. By selecting that compilation option you can run that aborted sequence from the point the sequence was aborted.
    Like for example, you have 10 jobs(job1, job2, job3 etc.) in a sequence and the job 5 aborts, then by checking "Add checkpoints so sequence is restartable on failure" and "Automatically handle activities that fail" you can restart this sequence from job 5 only. it will not run the jobs 1,2,3 and 4.
    Please check these options in your sequence.
    Hope this helps.

    Riten

    • May 30th, 2012

    To Handle Aborted Sequence These are the steps to be taken: First Add Terminator to Job Sequence and Choose Terminator with Other option(Trigger in Job sequence) ( if job fails it will go to Other lin...