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?
Solved
Schedule load in MDM
- Data Pioneer L2
- 11 replies
Best answer by AKislyakov
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
- Ataccamer
- 146 replies
- Answer
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
- Star Blazer L1
- 40 replies
Hi Team,
Can anyone please tell if a mdm job can be scheduled for a particular timezone? What timezone does the scheduler generally works on?
- Star Blazer L1
- 40 replies
Thank you.
Will raising a ticket help me know where the host server located?
Regards,
Aishwarya
- Ataccamer
- 146 replies
Usually, it is available in Java Properties section of Admin Center
1 person likes this
- Star Blazer L1
- 40 replies
This does not seem to be returning the timezone of where the server is located/the timezone I should use/consider while scheduling. For now, a coalleague helped me know our timezone. If I find anything that helps find the timezone for scheduling, I’ll update here
Reply
Most Liked this week
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.