Attunity Tasks Best Practices

galitzel — Mon, 05 Apr 2021 17:48:57 GMT

Hi,

How many tables are recommended to include per task in Attunity? Considering that we always use unidirectional replications.

Thanks

Re: Attunity Tasks Best Practices

john_wang — Tue, 06 Apr 2021 12:47:46 GMT

Hello @galitzel ,

From theory there is no limitation, however there must be some limitation to gain the best performance, include the network, CPU, memory, harddisk performance of the source DB, Replicate server, target DB etc. It depends on hardware , source DB /target DB database types and so on, it's hard to tell in a simple formula.

In general there are few thousands tables are included in a single task. As far as I know, one of our customer has more than 10K+ tables in a single task and all works fine, include Full Load and CDC.

Hope this helps.

Regards,

John.

topic Attunity Tasks Best Practices in Qlik Replicate

Attunity Tasks Best Practices

Re: Attunity Tasks Best Practices