New MDM Golden Records to have a unique ID that won't change even when the data of the Golden record changes. This ID will be used by other systems that receive/pull data from the MDM
Here our requirement is needed to generate MDM_ID as a custom field in BO table.in this field populating
below values like 'MH012345678'
1. All New Golden Records will have a unique ID
2. Once a New Golden Record has a Unique ID that Unique ID will not change
3. For the new records we need to get the maximum id values from the MDM_ID column which we are using in IDQ mapping to generate the MDM_ID(MH012345678) for the new records
1. Existing maximum record
2. We need to populate the MDM_ID values as like MH012345679,
could anybody please help on this scenario IDQ mapping?
Hello Ramesh ,
From th description ,I understad you want to generator alphanumeric serial numbers.You can use squence generator transformation for generation sequential values .
For geenrating alphanumeric serial number ,you can refer below KB :