Example: Ingress data with source last updated date
For example, you want to ingress records from Savings and Loan source systems.
The following table lists records from the Savings and Loan source systems:
Source System
First Name
Last Name
Gender
Phone
Source Last Updated Date
Savings
John
Smith
M
123456789
30/03/2021
Loan
Johnson
Smith
M
987654321
28/03/2021
The records from Savings and Loan source systems are merged to create a master record. The master record was created on 30/03/2021. When you ingress data from the Savings and Loan source systems the Savings record has the latest source last updated date. The master record is updated with the data from the Savings record.
The following table lists the updated data of the master record:
Record
First Name
Last Name
Gender
Phone
Last Updated Date
Master
John
Smith
M
123456789
30/03/2021
Source record with an old last updated date
When you ingress a source record with an older last updated date, the source record changes if you enable the Force Record Update option.
The following table lists the new data from the Loan source system to ingress:
Source System
First Name
Last Name
Gender
Phone
Source Last Updated Date
Loan
Johnson
Smith
M
332244556
27/03/2021
When Force Record Update isn't enabled
For example, if you don't enable Force Record Update and ingress new data from the Loan source system, the master record remains unchanged and the source record isn't updated with the old last updated date.
The following table lists the Savings, Loan, and Master records after you ingress new data:
Source System
First Name
Last Name
Gender
Phone
Source Last Updated Date
Savings
John
Smith
M
123456789
30/03/2021
Loan
Johnson
Smith
M
987654321
28/03/2021
Master
John
Smith
M
123456789
Not applicable
When Force Record Update is enabled
However, if you enable Force Record Update and ingress new data from the Loan source system, based on the last updated date of the Loan record, the source record changes. However, the master record isn't updated because the source last updated date of the Load record is not greater than the existing last updated date.
The following table lists the Savings, Loan, and Master records after you ingress new data:
Source System
First Name
Last Name
Gender
Phone
Source Last Updated Date
Savings
John
Smith
M
123456789
30/03/2021
Loan
Johnson
Smith
M
332244556
27/03/2021
Master
John
Smith
M
123456789
Not applicable
Source record with a newer last updated date
When you ingress a source record with a newer source last updated date, the master record is updated.
For example, you want to ingress a new record from the Loan source system.
The following table lists the data in the new record from the Loan source system:
Source System
First Name
Last Name
Gender
Phone
Source Last Updated Date
Loan
John
S
M
976597654
01/04/2022
When you ingress the new record from Loan source system, the master record changes. The master record is updated because the source last updated date of the new record from the Loan source system is 01/04/2021, which is newer than the source last updated date of the existing record from the same source system.
The following table lists the Savings, Loan, and Master records before you ingress records from the Loan source system:
Source System
First Name
Last Name
Gender
Phone
Source Last Updated Date
Savings
John
Smith
M
123456789
30/03/2021
Loan
Johnson
Smith
M
332244556
27/03/2021
Master Record
John
Smith
M
123456789
Not applicable
The following table lists the Savings, Loan, and Master records after you ingress the new record from the Loan source system: