Hello,
Your inputs on writing this assignment will be appreciated.
SQL:
update sds_mdm_business_partner
set first_name = trim(middle_name),
title = trim(translate(first_name,',.',' ')),
middle_name = trim(translate(
decode(personal_sfx,null,null,last_name),'.',' ')),
last_name = trim(decode(personal_sfx,null,last_name,personal_sfx)),
personal_sfx = null
where trim(translate(upper(first_name),',.',' ')) = 'MR'
Assignment Logic:
when the First Name is 'Mr, 'Mr.', 'MR', 'MR.' and so on, move it to the title field, move the middle name field to the first name field, move either the last name or the personal suffix field into middle name and last name, depending on if there is a value in the personal suffix field or not, and remove the personal suffix field.
Can we write this SQL in MDM .
Thanks
Bindi