MDM Tuple Update using Auto ID field of Main table

[Former Member]

Hi Experts,

I am getting an issue while updating the tuple in MDM.

The scenario is as follow:

We are using DEBMDM06, where one of the field of the XSD is populated with the Auto ID field of MDM.

This scenario is used for re-importing of data for updating the tuple.

Now, I have mapped all the tuple related fields and have mapped the Auto ID field that exist in XSD with the Auto ID field that exists in MDM and using the same field for Matching.

This matching works, but after executing import does not update the tuple, whereas it updates the rest of the fields of the Main table.

I am aware that Tuple does not support the Auto ID field, but I believe we can use this field ( belonging to main table) and execute import action for updating tuple.

Has anyone come across this issue? Can we use Auto ID as a matching field to update the tuple?

Thanks in advance.

Best Regards,

Parul Malhotra

[former_member207367 · Accepted solution]

Hi

Are you using Update Mapped Fileds or Update Null fields in the Tuple import action?

Thanks

Sowseel

[Former Member · Accepted solution]

Hi,

Thanks for the quick reply.

Yes I am using Update Mapped Fields - for existing

Create - New

Thanks with Regards,

Parul Malhotra

[former_member207367 · Accepted solution]

Hi

Have you tried with "Updated Null Fields", as Auto id is a calculated field we can not import any data in it. Try importing with "update Null fields " and let us know the result.

Check the Tuple update options in configuration options of you import map and import manager.

I do not have a MDM 7.1 system to check, update null fields should solve your problem

Let us know the results

Thanks

Sowseel

[Former Member · Accepted solution]

Hi Sowseel,

Thanks a ton... Update Null Fields worked...

Thanks again..

Best Regards,

Parul Malhotra