Four Stars

Talend datamodel change from SQL Server/MYSQL to Hadoop

Team,
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?