Data Lake & Services

Hi Experts,

I have source (SRC_TBL_EMP) and target table (TRG_TBL_EMP). Source having duplicate data and target have primary key on column EMPNO. When data comes from source to target then data flow will fail. In this case how to handle error out data with appropriate error messages into another table. Please help me here. Below is the data flow sample and table structure.

Thanks!

SRC_TBL_EMP

Name   Null?    Type         
------ -------- ------------ 
EMPNO           NUMBER(4)    
ENAME           VARCHAR2(10) 
JOB             VARCHAR2(9)  
MGR             NUMBER(4)    
SAL             NUMBER(7,2)  
COMM            NUMBER(7,2)  
DEPTNO          NUMBER(2)

TRG_TBL_EMP

Name   Null?    Type         
------ -------- ------------ 
EMPNO  NOT NULL NUMBER(4)    
ENAME           VARCHAR2(10) 
JOB             VARCHAR2(9)  
MGR             NUMBER(4)    
SAL             NUMBER(7,2)  
COMM            NUMBER(7,2)  
DEPTNO          NUMBER(2)