Loading table from one db to other db

[Talend_ent]

Hi all,

I have a scenario where mssql db having a table of more than 500 columns has to load the table into Teradata. Any Idea/suggestion would be appreciable.

Regards,

Talend_enth

[Anonymous]

Hello,

Which talend solution are you using? Talend open studio or subscription solution?

Here is a dynamic schema feature in talend subscription solution which allows you to design schema with an unknown column structure (unknown name and number of columns).

Please refer to this article about: https://community.talend.com/s/article/How-to-process-changing-data-structure-ExK7j

Best regards

Sabrina