Skip to Content
0
Former Member
Sep 17, 2008 at 03:52 PM

Assignments in data manager

23 Views

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