1 Reply Latest reply on Sep 3, 2021 2:40 AM by krishna priya somanchi

    MDM Golden Record ID for New Golden Records

    Ramesh M New Member

      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

       

      Example:

      1. Existing maximum record

      MH012345678

       

      2. We need to populate the MDM_ID values as like MH012345679,
                                                                                                      MH012345680,
                                                                                                      MH012345681....etc


      could anybody please help  on this scenario IDQ mapping?