-
1. Re: MDM history data load process
purusottam nayak Aug 14, 2019 2:10 PM (in response to Aditya Tirkovellur)Hi Aditya,
I believe you are discussing about Informatica multidomain MDM and not identity resolution.
could you please clarify if you want the latest PK to survive in the BO or the cell records from the latest PK.
The survivor is slightly different for PK and cell update.
Please refer to the MDM configuration guide for the details on the survivorship.
Please add some more details if you were looking for any other information.
Regards,
Puru
-
2. Re: MDM history data load process
Aditya Tirkovellur Aug 15, 2019 7:36 AM (in response to purusottam nayak)Hi Nayak,
Indeed infa's Multidomain MDM. To elaborate more, here is my scenario:
Lets say we do an initial load and we have multiple rows with same PK with different effective date.
i want to configure multiple versions of a record are loaded in same batch, where latest be in BO table and the rest(Old version records) into History table.
Below is the load multiple versions of a record from a staging table to a cross-reference table that is associated with a base object in one batch job.
Is it the only way to store the legacy history trace in MDM in XREF table? Or can we configure as per my question. Hope this makes sense.
thanks
-
3. Re: MDM history data load process
purusottam nayak Aug 20, 2019 2:40 PM (in response to Aditya Tirkovellur)My understanding is when you have multiple rows with same PK with different effective date all the records are available on BO but the one with the correct effective date will be in valid state.
All of them will not make it to the History table as this is the same record and we will not have 5 copies of the same record.