I have a requirement like below.
SOURCE TABLE : EMP_WORK_A
LOOKUP TABLE : EMP
Lookup on EMP on month_Wid and employee_num.
If there is not a match insert
source row EMP_WORK_A.x_hierachy_wid
If there is a match
check EMP_WORK_A.x_hierachy_wid = EMP.ac_Hier_id
if there is a match, populate EMP.Target_Hier_id
else populate EMP_WORK_A.x_hierachy_wid
Can anyone give quick suggestion on this?
Thanks in advance,
Can you help me understand if you are planning to implement this using Power Center or using Data Quality?
Based on your inputs, I can help you with the above queries.