I have MDM setup and records are loaded using a Full Laod configuration. I need to create a load such that all the records that were added into the source are moved into to MDM hub on a daily basis. The approach being used is to identify all the records updated today and load them into MDM. Can you please suggest if I need to create a Delta Load for this or Full Load works. Also, I need to schedule a run of the load file on daily basis.How can I do it?
Page 1 / 1
Hi
A Full Load can work if you're transferring all records from the source to the MDM. In that case, the Full Load compares source records with their copies on the MDM and determines each record's status (unchanged/updated/inserted/deleted), then processes them accordingly.
If you want to minimize the amount of data transferred, you can create a Delta Load. You can extract newly updated/inserted/deleted records from the source using timestamps or audit logs and transfer only those records to the MDM, providing their change type so the MDM can process them correctly.
As for scheduling such loads you can use the Scheduler to schedule a workflow that performs an MDM Load
Reply
Login to the Ataccama Community
No account yet? Create an account
For Ataccama Customers and Partners
or
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.