I need your help on below design.
Two disparate data warehouse applications – MYSQL and SQL Server. Data is loaded into the warehouse using Talend.
Consolidate up to 200 tables from each of a MYSQL and a SQL Server data warehouse into a single three node Hadoop environment.
Can you please let me know how to change existing target from SQL Server/MYSQL to Hadoop and what are all the limitations. How can I do the incremental load to Hive DB Hadoop?
Can you send me architectural process?