Hi Experts,
I'm new to Qlik Replicate and trying to learn the tool & its concepts using community & web.
There is a requirement to migrate data from Oracle database to Snowflake.
The data volume is very big. We have around 10 TB of data and more than 1000 tables.
I've a demo session on Qlik Replicate. There I learned how it works.
So, I need to create Oracle as a source point and Snowflake as Target destination.
But I've few questions:
1): How much data we can migrate from Source (Oracle) to Target (Snowflake)?
2): Does the large volume of data effect the performance on source as well as Target Servers?
3): How much time it will take to transfer 10 TB of data and more than 1000 tables from source to Target?
4): Do I need to create one task for transfer or multiple tasks for it?
5): Can this migration performed by a single resource or does it requires a team effort?
6): Can I perform Full load here?
7): What is the difference between Full load, Apply changes & Store changes?
Please revert with your experienced answers.
Regards,
Eric
