topic [resolved] How to delete all the data from an MDM entity as quick as possible in Talend Data Catalog

[resolved] How to delete all the data from an MDM entity as quick as possible

Anonymous — Tue, 02 Sep 2014 09:20:31 GMT

Hi
I currently have +- 300k records for an entity in MDM. I want to delete all these records but the process is going really slow (around 20records/s).
My setup is: tMDMInput ---> tMDMDelete
Is there anyway to speed up the process?
Kind Regards
Dries

Re: [resolved] How to delete all the data from an MDM entity as quick as possible

Anonymous — Tue, 02 Sep 2014 09:54:19 GMT

Hi,
Did you look in the tMDMDelete documentation here? Since 5.4, tMDMDelete includes a way to delete all instances matching some criteria you can define in tMDMDelete.
Regards,
François.

Re: [resolved] How to delete all the data from an MDM entity as quick as possible

Anonymous — Tue, 02 Sep 2014 10:22:52 GMT

Hi
Thank you for your fast reply. I overlooked that option!
Kind regards
Dries

Re: [resolved] How to delete all the data from an MDM entity as quick as possible

Anonymous — Tue, 02 Sep 2014 12:50:54 GMT

Goto advanced setting in tMDMInput component and increase Batch size.