DML Error Tables

Today we are going to explore the DML Error Logging using OWB11R2.

1.Already created module and location with SCOTT user.

2. Will try to insert the records into DEPT table having primary key on DEPTNO.

3.Mapping will look like this :- Dept1 -> Dept

4.Check the data in DEPT table from Sqldeveloper. 8 rows

5.Check the data in DEPT1 table from Sqldeveloper . 12 row

all are 12 rows are already present into target table (DEPT)

6.Configure the mapping to Handle DML Error Table as DEPT_ERR.

7.After mapping execution the all the 12 records are there in DEPT_ERR table and

Mapping run successfully.