Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2014

    Unanswered: Data Validation from staging table

    Hi guys need urgent help for following problem

    I have 2 tables emp1(ename,empno,job,mgr,hiredate,sal,comm,deptno)
    and dept1(deptno,dname,loc) i filled some data into following staging table
    emp_validate_staging(empno,ename,deptno,dname,stat us) which has both correct and incorrect data.
    Now i have t write a package which validates the data given in the staging table(Eg- the following data exists/not exists in emp1/dept1 table, use seperate blocks for seperate tables) and update the status in the staging table with 'W','R'. if the status is 'R' then insert that data into another table emp_valid_transaction or else should throw an exception.


  2. #2
    Join Date
    Jun 2003
    West Palm Beach, FL


    Interesting homework, what have you done so far?
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts