6 Replies Latest reply: Mar 19, 2014 10:10 AM by edy12 RSS

    Data validation from a 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,status) 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.

      Basically i am not able to validate the data so please help me with this